Replace all values of a data table

[CristianZachiteanu (Cristian Nicolae Zachiteanu)]

You can take a look at this post to replace your values before doing the compare.

Replace values in a DataTable without ForEach (loop)

Hi All, I have struggled with a function to replace values in a DataTable and after 3 days of searching I have discovered two which I like to share with the community. To replace all values which meet a specific criteria in a DataTable on all columns I have used the following: (From r In InitialDT.AsEnumerable Select ia = r.ItemArray.ToList Select ic = ia.ConvertAll(Function (e) system.Text.RegularExpressions.Regex.Replace(e.ToString.Trim, “^$”, “0”)).ToArray Select ResultDT.Rows.Add(ic))…