Case Sensitive in Filter wizard

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


Hi @Sax72,

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

elenco_in.CaseSensitive = False


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.


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…

1 Like


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.