How to use like operator in select method

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

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

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

https://www.csharp-examples.net/dataview-rowfilter/

2 Likes

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.

Use Filter Data Table activity.

DataTableSelect.xaml (9.9 KB)

1 Like

Thanks .This worked

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