Remove character from the entire datatable

Help
1

Hi all

I was wondering if there is any way to remove a specific character in all the table values. I tried for each row activity column.Item(“column1”).ToString.Equals(“-”) but my table has more than 100 columns. Is there some way to denote for any column?

Thanks for any help

2

hello @C_Mark

the below workflow can help you.

Replace in DAta table.zip (14.0 KB)

give a try

Regards
Ajay

3

Hello @C_Mark
you can try below as well…
write your datatable to CSV file…

Read CSV file as text file into variable e.g = strDt
strDt = strdt.Replace("-","")
Write strDt into text file give full CSV file path (C:\temp\strDt.csv)
Read that CSV to into Datatable with Read CSV activity