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.
Hi @slckkrky the REGEX_MATCH() function has to match the entire string, so if you change yours to:
then you'll get what you want. You've also got your contains function round the wrong way. The first parameter of Contains() should be the string you're searching, the second is what you're searching for.
For this method, it looks for full string matches rather than partial matches, so based on that, for that function to work, you need to insert .* at the beginning and the end to control anything else in your string.