Searching Names within a fiels

Hi Folks, I'm getting some inconsistent results when attempting to extract names from within a field that can contain between 1 and 100 values. I've been using the contains function: Contains([name field], 'Russell') Or Contains([name field], 'RUSSELL').

When I go over to SQL I'm using the function iLike: ILIKE '%Russell%'

I'm getting considerably more hits using SQL. I'm curious what others use. Is there a better method to use in my Alteryx work flow?

Thanks,

George

Data Investigation

Accepted answers

barrymoe

Can you give an example of what is popping up with the ILIKE vs. the contains?

Also you can look for case insensitive with Contains([String],"text",1)

All comments

barrymoe

Can you give an example of what is popping up with the ILIKE vs. the contains?

Also you can look for case insensitive with Contains([String],"text",1)

alexnajm

ILIKE seems to be just a case insensitive version of LIKE (PostgreSQL ILIKE), so I agree that @barrymoe 's solution is best and I don't see why it would give different results. I'd like to see an example too

gfisch13

Thank you @alexnajm @barrymoe, Like you I was baffled by this outcome but have come to find out that there were some missing delimiters in my data that was restricting the number of records read from my CSV file. I'm working to setup a direct connection to this data so that I can skip the download step. Appreciate your input!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703