Remove special charecters form the column expect digits without for each loop

Hi Guys,

I want to remove alpha numeric charecters from the column except digits…i have done it using

this expre: System.Text.RegularExpressions.Regex.Replace(row(“Tracking #”).ToString, “[^0-9]”, “”) by using for each loop…

but i dont want to use for each …so can any one help me out this.


The same expression can be used in Linq .

Thanks Priyanka! can you please elaborate it i never used linq…screenshot will be more useful…

(From row As DataRow In dataTable
Group row By id = row.Field(Of String)(“ID”) Into Group
Select {id, From i In Group Select
System.Text.RegularExpressions.Regex.Replace(i.Field(Of String)(“Age”).ToString, “[^0-9]”,"")}).ToList