Issue in data filtering

[arj (Arijitr)]

hi,
I want to keep those records from a datatable where the length of a particular field (Additional Contact Mobile No) =10 or 8.
I want to keep only those records where length is either 10 or 8.
How can i do this?

[ppr (Peter)]

Give a try on:
Assign activity
leftside: dtFiltered | DataType:DataTable
Right side:

(From d in YuurDataTableVar.AsEnumerable
let acmn = d(yourColNameOrIndex).toString.Trim
Where acmn.length = 8 Or acmn.length = 10
Select r=d).CopyToDataTable

handling empty filter result can be done with following patterns:

[arj (Arijitr)]

hi @ppr Thank you.
I want to learn linq query. Can you please tell me the best resources to learn about linq query.

[ppr (Peter)]

Currently we are working on rolling out a tutorial series on learning LINQ. Have a look on the first tutorials here:

[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) Operators 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 # All Operato…

we suggest to start with learning the basics on List/Array base. With some more practice doing LINQ on datatables will be easier and more sucessfully.