Filter Datatable with condition

Help Studio
, ,
1

Hi ,

How to use filter data table activity to filter data with condition - in column1 should contain letter x, in column 2 should filter row with single digit.

image
image724×379 9.34 KB

Thanks in Advance

2

Hi,

How about the following?

image

Regards,

3

Hey

give a try with

dtDuplicates.AsEnumerable.Where(Function(x) x("Name").ToString.Trim.ToUpper.Contains("X") And x("Value").ToString.Length = 1).CopyToDataTable

Regards

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.