How to remove empty spaces from the numbers

Help Studio
, ,
1

I have spaces in my excel column. how can i remove the spaces, I tried with Trim but it is not working.
for ex:
Total
1 2345
12 2345
1 6789
123 12
Can any one please help me to fix this issue.

2

HI,

How about Replace method, as the following?

image

yourString.Replace(" ","")

Regards,

3

Hello @Chippy_Kolot ,
Kindly refer this regex expression. It will remove any whitespace betweeb the values

System.Text.RegularExpressions.Regex.Replace("12   234   5","\s+","").ToString

Var1=“12 234 5”

System.Text.RegularExpressions.Regex.Replace(Var1,"\s+","").ToString

image

4

use .replace(" ",string.empty)

5

Hi @Chippy_Kolot, I hope you are doing well.
For your current problem I am attaching an workflow for your reference which might help you to get a solution and understand.
Main.xaml (11.0 KB)

Have a good day!

Thanks & Regards,
Shubham Dutta