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
Have a Look Here giving some Help on the Syntax
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)
Thanks .This worked
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.