Deleting blank spaces from a data table

[lemoinethomas (Lemoine)]

Hello !

I am looking to delete the blank spaces from a certain column in my Datatable.
I the column, i have data written like “71 111” and I would like to be able to have “71111” so I can use it as an integer for further processing.

If possible, i would like to avoid interaction directly with the excel file (send hotkey, find and repalce , etc …).

Any ideas ?

Best regards,
Thomas

[ddrdushy1 (Dushyanth)]

@lemoinethomas

71 111

get the value to a temp variable
create assign temp=temp.Replace(" ","")
now temp will have value without spaces.

[lemoinethomas (Lemoine)]

@ddrdushy1

" “,”")

Perfect ! Thanks !