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.
with contains does it work for part of the string like
example in the column it got Asset or Asset or Asset
can I use the formula as
IF CONTAINS([COLUMN], "Asset")
Hello @ashac ,
you could use also the formula StartsWith for that matter.
IF StartsWith ([COLUMN], 'Asset') THEN "CORRECT" ELSE "INCORRECT" ENDIF
No that would not work because CONTAINS will only work for things that match everything within the quotation marks.
For this situation, you can either just use:
Alternatively, a smarter better solution would be use to REGEX.
Use the formula below for your solution.
IF REGEX_Match([COLUMN], "Asset\[\d+\]")
What the REGEX does is that it looks for anything that has "Asset[", then any number of numbers, then closed with "]".
Let me know if this helps with your issue.
Another option would be using regex match
IF REGEX_Match([Field1], 'Asset\[\d*\]') THEN "CORRECT" ELSE "INCORRECT" END