SQL Sintaxys - Field NOT LIKE 'abc%'

[GusDC]

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.

[binuacs · Accepted solution]

@GusDC The !StartsWith([Field], ‘ABC’) will have the same functionality 

[simonaubert_bd · Accepted solution]

Hello. Can you try that :  left([myfield],3)!='ABC' ?

[geraldo · Accepted solution]

@GusDC 

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

[GusDC]

Thank you very much Guys!  😊

[GusDC]

Thanks!! :)