Does not contain criteria

[DiyaR]

I am trying to replicate my Access query but failed. My code should not contain "*33" and "XX*" and number should not be like "920*"

[Thableaus]

Hi @DiyaR 

!(Contains([Code], "33") OR Contains([Code], "XX"))

AND 

!Contains([Number], "920") 

Try this out.

Cheers,

[DiyaR]

I actually tried this out.. however,I want code which ends with 33 and XX, Number starts with 920. Do i have to go with Regex??

[danilang]

Hi @DiyaR 

Look into the StartsWith() for XX* and 920* and Endswith() functions for *33.  preface both of these with Not to match your requirements 

Dan

[ChrisTX]

Since your Access query is using wildcards, try the Alteryx function REGEX_Match

[jamielaird · Accepted solution]

Or use Left([fieldname],2)=“XX” and Right([fieldname],2)=“33” etc to specify the first or last two digits.

[DiyaR]

thank you.. It worked 🙂