How to remove whitespaces in the excel

Help Studio
, ,
1

In my Excel column “Total” it contains white spaces
eg:{4 177,
7 890,
1 234,
5 1890 }
How to fix this issue

2

@Chippy_Kolot , Try this
“4 177”.Replace(" “,”")
From this you can remove the white space

Currentrow(“Total”).Replace(" “,”").tostring.trim

3

Hello @Chippy_Kolot

Either you can loop through each value in excel and replace the space .
Else you can convert the datatable to string and replace the spaces using replace method.

4

(From r in DT.Asenumerable
Let a = r.itemarray.select(Function(v) v.Tostring.Trim).Toarray
Select DT_Clone.Rows.Add(a)).Copytodatatable

5

Hello @Chippy_Kolot Please refer below thread

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.