# Case Sensitive in Filter wizard

**URL:** <https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585>\
**Category:** Help\
**Tags:** system, activities\
**Created:** [July 28, 2019, 4:10pm UTC](https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585 "2019-07-28T16:10:25Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sax72](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sax72/32/43443_2.png) [@Sax72](https://forum.uipath.com/u/Sax72)\
**Post date:** [July 28, 2019, 4:10pm UTC](https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585/1 "2019-07-28T16:10:25Z")

</div>

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](https://global.discourse-cdn.com/uipath/original/3X/f/3/f3f0caeeb38da1556923d71c3cf224633d541cc7.png)  
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

---

<div class="post-metadata">

**Author:** ![msan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/msan/32/110167_2.png) [@msan](https://forum.uipath.com/u/msan)\
**Post date:** [July 28, 2019, 5:00pm UTC](https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585/2 "2019-07-28T17:00:37Z")

</div>

Hi @Sax72,

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

`elenco_in.CaseSensitive = False`

> **[DataTable.CaseSensitive Propriété (System.Data)](https://learn.microsoft.com/fr-fr/dotnet/api/system.data.datatable.casesensitive?view=netframework-4.8)**
>
> Indique si les comparaisons de chaînes au sein de la table respectent la casse.

---

<div class="post-metadata">

**Author:** ![Sax72](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sax72/32/43443_2.png) [@Sax72](https://forum.uipath.com/u/Sax72)\
**Post date:** [July 29, 2019, 5:39am UTC](https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585/3 "2019-07-29T05:39:08Z")

</div>

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

 ![immagine](https://global.discourse-cdn.com/uipath/original/3X/d/1/d1bbbc3dac5769727df9b5e5d80a8368c9bb077d.png)  
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 ☹  
if you want I can share the xmal file.

Thanks  
Sax72

---

<div class="post-metadata">

**Author:** ![Lahiru.Fernando](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/lahiru.fernando/32/523857_2.png) [@Lahiru.Fernando](https://forum.uipath.com/u/Lahiru.Fernando)\
**Post date:** [July 29, 2019, 5:47am UTC](https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585/4 "2019-07-29T05:47:17Z")

</div>

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()

---

<div class="post-metadata">

**Author:** ![Sax72](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sax72/32/43443_2.png) [@Sax72](https://forum.uipath.com/u/Sax72)\
**Post date:** [July 29, 2019, 6:42am UTC](https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585/5 "2019-07-29T06:42:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Lahiru.Fernando](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/lahiru.fernando/32/523857_2.png) [@Lahiru.Fernando](https://forum.uipath.com/u/Lahiru.Fernando)\
**Post date:** [July 29, 2019, 7:33am UTC](https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585/6 "2019-07-29T07:33:33Z")

</div>

@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… 🙂

Thank you!!

Happy automating!!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [August 1, 2019, 7:33am UTC](https://forum.uipath.com/t/case-sensitive-in-filter-wizard/137585/7 "2019-08-01T07:33:36Z")

</div>

Closed on August 1, 2019, 7:33am UTC

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