How to use like operator in select method

[pratiksha_pawar]

Hi,
I want to use the like operator in select method how can I use it?

[pratiksha_pawar]

I wan to read row from datatable which contains the value “Cnt” in it

[ppr (Peter Preuss)]

@pratiksha_pawar
Have a Look Here giving some Help on the Syntax

DataView RowFilter Syntax [C#]

[ClaytonM]

Here’s just a quick example in vb .net using linq

dt1.Select.Where(Function(r) r("columnname").ToString.ToLower.Contains("cnt") ).ToArray
then, you can run that through a For Each, Or output it to another file by first checking its count with .Count and if it found rows, then add .CopyToDataTable to the array variable to place in a Write Range.

[ui_xpath]

Use Filter Data Table activity.

DataTableSelect.xaml (9.9 KB)

[pratiksha_pawar]

Thanks .This worked