Removal of unwanted characters from table

Help
1

i have a table in excel which has the following characters in it

image
image885Ă—163 11.5 KB

i want to remove all these strings from the table, if they exist
soo how should i do it using UiPath.

2

Use regex on every column and replace it with blank:
Regex - “[^0-9a-zA-Z]” → it will only allow characters and numbers.

Syntax in UiPath: System.Text.RegularExpressions.Regex.Replace(“Your String”,“[^0-9a-zA-Z]”,”")

1 Like
3

@Aishwarya_Bhargava
Lets assume your data is in a datatable

have a look here on replacing a value in all rows and columns
Replace_AllCellsAllRows.xaml (7.5 KB)

just change the string insed the replace method

1 Like