How to remove special characters from data generated by data scrapping

[Mathkar_kunal]

Hi,

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?

@NIVED_NAMBIAR

[NIVED_NAMBIAR (NIVED N)]

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 vb.net.

Where the dt1 is the datatable

Hope it helps you

Mark it as solution if it resolves ur query

Regards

Nived N
Happy Automation