Activity Filter Data Table column to lower

Hi!
How in activity Filter Data Table convert string column to lower in filtering field?
It must be column Name to lower.
Or is it impossible to do in this activity?

image

No unfortunately, you just need to type the column name exactly as it is, and its case sensitive

a work around that would allow you to use the .ToLower() function is using for each row to filter through your DT

Thanks!
And in method DataTable.Select case does not matter? In datable name “John” and in condition use “JOHN” and Select return 1 record!

1 Like

@Aleksey_M
General reference on filtering:

for the select method following Docu can be refered:
https://www.csharp-examples.net/dataview-rowfilter/

With LINQ (Quick Approach, not handling empty result)
(From d in YourDataVar.AsEnumerable
Where d(YourColNameOrIndex).toString.toLower().Equals(yourSearchTerm.toLower())
Select d).CopyToDataTable

1 Like

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