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!!

@mkankatala one more thing. I need to remove the USD from D column also. Can I include in same expression?

Could you raise new query for this… @marina.dutta

@mkankatala Tagged you in the new Query. Can you please help on this two below links ? [image] Remove character and format date in DataTable Studio Hi, I want to remove the USD from excel column and format the date to to one format MMDDYYYY . Can I do this in single li…

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
Remove character and format date in DataTable Studio studio , question , tools	11	310	March 7, 2024
How to remove special characters in excel data table like for one sheet Something Else feedback	11	2296	December 16, 2022
Delete special characters from datatable Something Else feedback	2	90	February 11, 2025
Remove all alphabets and special characters from entire column of a datatable Activities excel	1	799	December 12, 2022
How to smartly remove some special characters and some strings (if those exist) from column data in a datatable? Help	3	3659	July 18, 2019

Error in Regex Expression

Related topics