Hi guys,
Wich is the similar sintaxis in Alteryx of this not like 'ABC%' in SQL? I need to put in a filter tool.
Thanks.
Solved! Go to Solution.
@GusDC The !StartsWith([Field], ‘ABC’) will have the same functionality
Hello. Can you try that : left([myfield],3)!='ABC' ?
If you want to explore with regex it can be like this:
insensitive case:
REGEX_CountMatches([text], '^ABC') = 0
sensitive case:
REGEX_CountMatches([text], '^ABC',0) = 0
Thank you very much Guys! 😊
Thanks!! :)