DataTable match only rows with 6 digits in Column0

[VanjaV]

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()

Thx for suggestions and kind regards,
Vanja

---

1. 0-9 ↩︎

[J0ska]

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

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

Cheers

[Sudharsan_Ka]

Hi @VanjaV

How about this expression

dt.AsEnumerable().Where(Function(s) System.Text.RegularExpressions.Regex.IsMatch(s("Column2").ToString,"\d{6}")).Select(Function(a) a).CopyToDataTable

Or

dt.AsEnumerable().Where(Function(s) s("Column2").ToString.Trim.Length.ToString.Equals("6")).Select(Function(a) a).CopyToDataTable

Regards
Sudharsan

[Rahul_Unnikrishnan]

Hello @VanjaV

Have you checked the same with filter datatable activity?

Thanks