This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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.