topic RE: Remove additional spaces from string in University Forum

Remove additional spaces from string

Devendra_KumarP — Fri, 08 Jul 2022 10:47:00 GMT

Hi All,

There are multiple ways to remove additional spaces from a string. like split string by spaces then combine again with one space. Just wanted to check if there any other simple way to do this.

Requirement - remove additional spaces from string.
Example - "Devendra Kumar Prajapati" should be converted to "Devendra Kumar Prajapati"

------------------------------
Devendra Kumar Prajapati
RPA Manager
Infosys
Chandigarh, India
------------------------------

RE: Remove additional spaces from string

Satish1414 — Fri, 08 Jul 2022 11:55:00 GMT

Hi Devendra ,

First check with InStr that if there are more than one extra space in the string (If "YES" InStr will return the position of the searched string)

If yes use "Replace" the function to update the Name

Hope this helps .

Regards,

Satish Gunturi

Senior Consultant

Ignite IPA Pvt Ltd.

------------------------------
Satish Gunturi
------------------------------