AC
Rank: #792
911Views
4Comments
Solved
Remove Space between the string
Question

Hi ,


I want to remove Space between string  how we can do it  for example i have string -

Country Details , i  want to change to >> countryDetails 

how we can do it please suggest .

1
0
on 2018-02-02
Copy link to comment
Samuel M.
Rank: #428
Solution

Hi,

I think you can use the Replace Built-in Function to do that. Something like Replace("Country Details", " ","").

Regards,
Samuel

3
0
on 2018-02-02
Copy link to comment
AC
Rank: #792

Thanks Samuel  its worked..

0
0
on 2018-02-04
Copy link to comment
Carolina Bessa
Rank: #653

Just additionally to this topic, recently I got the issue that Replace(" ","") and Trim() were not having effect on data coming from Excel so I had to add the other replaces:

Replace(Text, Chr(160), Chr(32))
Replace(Text, Chr(9), Chr(32))
And then I did Trim(Text)

0
0
on 2020-11-06
Copy link to comment

Hi Carolina,

Thanks for sharing this option more

0
0
on 2020-11-06
Copy link to comment