Activity Filter Data Table column to lower

Help Studio
1

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

2

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

3

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
4

@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

2 Likes
5

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