How to remove special characters from data generated by data scrapping


I am generating data by data scrapping but it includes special character like 
in excel u can see in below screen shot.
how can i remove those?

Try to use this code in invoke code

dt1.AsEnumerable().ToList.ForEach(Sub(row) row(“Name”)= System.Text.RegularExpressions.Regex.Replace(row(“Name”).ToString ,“[^A-z 0-9 _]+”," ").Value)

Put the dt1 as argument with type as In/out in invoke code with language type as

Where the dt1 is the datatable

Hope it helps you

Mark it as solution if it resolves ur query


Nived N :robot::robot:
Happy Automation :relaxed::relaxed::relaxed:

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