Case Sensitive in Filter wizard

Hi,
I’m using Filter wizard in the filter data table, as far as I understood Filter Wizard filter data table is case sensitive…
is not possible to set the case sensitive off ?


In the filter Wizard if I write Sam or sam is different, I would like no difference between sam and Sam and SAM

Thanks
Sax72

Hi @Sax72,

Prior filtering, you can set your DataTable case insensive with an Assign activity

elenco_in.CaseSensitive = False

https://docs.microsoft.com/fr-fr/dotnet/api/system.data.datatable.casesensitive?view=netframework-4.8

2 Likes

Hi Msan,
thanks for your message unfortunately doesn’t work :frowning:


I also tried with a variable instead to write directly the value.
in both cases (write directly or vaiable) if write “Mario” instead “mario” it works :frowning:
if you want I can share the xmal file.

Thanks
Sax72

Hi @Sax72

You can also try converting the required columns into either fully upper or lower case to support your need.

Use a for each row loop, and within the loop, convert the data to lower or upper
row(“ColumnName”) = row(“ColumnName”).ToString.ToLower()

1 Like

Hi Fernando, Thanks in this way it works…
Thanks
Sax72

1 Like

@Sax72

Glad to know I was able to help you…

If my answer helped you to fix it, please mark it as the solution too… :slight_smile:

Thank you!!

Happy automating!!

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