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've been looking across multiple threads but couldn't find anything exactly what I needed. I know that I can use things like CONTAINS() and REGEX_MATCH() to find specific characters within strings, akin to something like:
LIKE '%HELLO_THERE%' in SQL, using the % as wildcard for anything that comes before or after my characters. I could write CONTAINS([Field],'HELLO_THERE') and get that result in Alteryx.
My question comes about with Wildcards in the middle of the string - in SQL it could look like:
LIKE '%HELLO%THERE%', and then it will return anything where the word HELLO precedes the word THERE, regardless of any characters before, between, and after it. Is there anything within Alteryx that would achieve this? I've tried a combination of formulas / values and can't seem to work it out.