Is there a way to use the LIKE operator to make it case insensitive, specifically in the ETL?

DWill978 · 2024-04-11T17:07:49+00:00

There was an error rendering this rich post.

I have looked through the Community Forum trying to find a way to make LIKE case insensitive. I came across a way using ILIKE in the formula tile, but after trying it I found that it didnt work in the Formula. I am specifically looking for a way in the Filter tile.

Find more posts tagged with

Accepted answers

MarkSnodgrass

Yes. you should be able use the LIKE operator in the filter tile. I would add the LOWER or UPPER function to make it case insensitive. Adding the % sign around your string will make it a wildcard search. Like this:

LOWER(statename) LIKE '%tex%'

All comments

MarkSnodgrass

LOWER(statename) LIKE '%tex%'

Sean_Tully

I think if you wrap the field in UPPER, and the string pattern after LIKE is uppercase, this should accomplish what you want. Works for LOWER and lowercase, too.

DWill978

https://community-forums.domo.com/main/discussion/comment/94847#Comment_94847

Thank you for your thoughts on this matter, I ended up getting the ILIKE operation to work I forgot to include the % in my quotes. Thank you for the fast response