Case Sensitive in Filter wizard

Help
1

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 ?

immagine
immagine702×278 8.48 KB

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

2

Hi @Sax72,

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

elenco_in.CaseSensitive = False

2 Likes
3

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

immagine
immagine900×454 20.9 KB

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

4

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
5

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

1 Like
6

@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!!

7

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