Hi All, I am trying to remove special characters in DataTable using regex (Here I dont want $,USD and any space or dot. I am using following regex expression however getting error (From r In DT1.AsEnumerable Select ra = r.ItemArray.Select(Function (x) System.Text.RegularExpressions.Regex.Replace…

Hi @marina.dutta There is a small modification in the code, check the below one, (From r In DT1.AsEnumerable Let ra = r.ItemArray.Select(Function (x) System.Text.RegularExpressions.Regex.Replace(x.toString,"[^a-zA-Z0-9]","")).ToArray() Select dtout.Rows.Add(ra)).CopyToDataTable() Hope it helps!!

Error in Regex Expression

Help Studio

marina.dutta (Marina Dutta) March 7, 2024, 9:03am 5

@mkankatala

Tagged you in the new Query. Can you please help on this two below links ?

Topic		Replies	Views
How to remove special characters in excel data table like for one sheet Something Else feedback	11	1872	December 16, 2022
Using Regex to Replace Text in a Datatable Studio studio , question , activities_panel	4	807	November 7, 2022
Using Regex to edit datatable values Studio datatable , studio , variable , regex , string , question , activities_panel	3	906	January 16, 2023
Regex, SubString or Linq? Activities datatable , excel , activities , studio , question , word	11	844	March 13, 2023
Filter DataTable with special characters Help	7	4215	September 3, 2020

Most Active Users - Yesterday
Yoichi
Raja.G
mkt.scott4
More details...

Error in Regex Expression

Related Topics