nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to club case insensitive search with regex_match

ferha_jafri

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

Preparation

Accepted answers

phottovy

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

RegEx_Match.yxmd

All comments

phottovy

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.

ferha_jafri

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15898

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703