I would like to know how to remove parentheses and whitespace from all the values in a DataTable while keeping the structure (rows and columns) intact. If I use System.Text.RegularExpressions.Regex.Replace(TestDT, "\s*\(.*?\)\s*", ""), I would need to convert it to a string, which would disrupt the …

Hi @22222222asas , Based on the regex you provided refer the xaml attached below for the solution. Test.xaml (8.4 KB) The LINQ query iterates over each row in the DataTable and applies the Replace function to every item (cell) in the row, removing whitespaces and parentheses. It then adds the modi…

The method to use Replace in a DataTable help

Help Studio

Shahazeer_Ummer_D (Shahazeer Ummer D) October 18, 2024, 7:30am 4

dt_test.AsEnumerable().Select(Function(row) dt_clone.LoadDataRow(row.ItemArray.Select(Function(item) item.ToString().Replace(" “, “”).Replace(”(“, “”).Replace(”)", “”)).ToArray(), False)).CopyToDataTable()

You can try this out instead of using regex.

2 Likes

Topic		Replies	Views
Replace values in a DataTable without ForEach (loop) Off-Topic Discussions studio	2	6445	June 24, 2021
Replace quotes in a string StudioX studio , string , replace-text	4	1416	May 21, 2022
Need to remove whitespace from datatable specific column Activities datatable , excel , selector , database , uiautomation , pdf , mail , orchestrator , robot , activities , studio , data_scraping , studiox , question , activities_panel	7	5295	February 11, 2022
Manipulation on Datatable -help Studio datatable , excel , uiautomation , robot , activities , studio , question , data_manipulation , activities_panel	6	1713	January 12, 2022
Loop through all the cells of a datatable Something Else	4	1147	February 23, 2023

The method to use Replace in a DataTable help

Related topics