Hi, I need to keep in datatable only rows where “Column0” contains 6 digits. What is wrong with following statement? dt = dt.AsEnumerable().Where(Function (row) row(“Column0”).ToString. Equals(System.Text.RegularExpressions.Regex.Match(row(“Column0”).ToString,“ [1] {1,6}$”))). CopyToDataTable() T…

Better like this: dt = dt.AsEnumerable().Where(Function (row) System.Text.RegularExpressions.Regex.IsMatch(row("Column0").ToString,"[0-9]{6}$")). CopyToDataTable() And alos check this post [image] [HowTo] LINQ (VB.Net) Learning Catalogue Tutorials This topic references t…

DataTable match only rows with 6 digits in Column0

Help Studio

Rahul_Unnikrishnan (Rahul Unnikrishnan) December 27, 2022, 2:08pm 4

Hello @VanjaV

Have you checked the same with filter datatable activity?

Thanks

1 Like

Topic		Replies	Views
Linq query with regular expression Studio studio , question , reosurce_panel	9	4882	November 23, 2021
Filter Data Table To Get Only Even Numbers Help datatable	12	2781	February 2, 2022
Remove the Rows contains Only Integer value Studio datatable , excel , studio , question , command_palette	7	1663	March 4, 2022
Leave only the integers in a column Help datatable , excel , activities , question	10	1645	January 4, 2021
Filter DataTable End with Numbers Studio studio , question , variables_management	2	1177	March 29, 2022

DataTable match only rows with 6 digits in Column0

Related topics