Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to club case insensitive search with regex_match

ferha_jafri
8 - Asteroid

Hello Team,

 

I have a requirement in which I want look for the case insensitive string and then match it with a particular string to get the result.

Eg. in a column I have a string "pattern to be follow"  so I want to search for "pattern to" with wildcard and then get the complete string "pattern to be follow"  and then compare it with other field with case insensitive search i.e. it should get all strings with "pattern to be follow" irrespective of the case.

 

Thanks in advance

6 REPLIES 6
phottovy
13 - Pulsar
13 - Pulsar

Hi @ferha_jafri,

 

By default, the regex_match formula is case insensitive. In the image below, you can see the third option "icase=1" allows you to tell the formula to either be case sensitive (0) or case insensitive (1). Let me know if I missing something in your question. 

 

phottovy_0-1620146961019.png

 

ferha_jafri
8 - Asteroid

Thanks, my requirement is first I want to check for wild card I.e. first it will match first few characters in a string and then it will compare for case insensitive.  

phottovy
13 - Pulsar
13 - Pulsar

You should be able to accomplish this through RegEx. Do you have a couple examples that you can share?

ferha_jafri
8 - Asteroid

For e.g. I have a column comment in which I have to compare part of comment with the initial few words like the complete comment is "interest rate is 5 % till march" so I want to compare "interest rate*" after comparison it should return the complete string which I will again compare for case insensitive I.e. it should return-1 for the match irrespective of the case.

Qiu
20 - Arcturus
20 - Arcturus

@ferha_jafri 

Maybe we can try Find and Replace instead if you dont insist on using RegEx_Match?

Capture2A.PNGCapture2B.PNG

phottovy
13 - Pulsar
13 - Pulsar

Try the formula in the attached workbook. The ".*" basically says count anything past the words "interest rate" as a match.

Labels