REGEX

[hi2019]

So,

I am using this 

!REGEX_Match([City],'^(\s*|\d+|[^\w\s]+)$')

to show this if OWNER-CITY field is null, only spaces, contains a number, or is only a symbol(s) move entire record to separate tab “Manual Review”

I am only trying to flag it then I can move it to another tab but its NOT picking this one: 1PEWAKEE

Why? it seems to be flagging all but this one?

thanks

[cjaneczko · Accepted solution]

Try the following

!REGEX_Match([City],'^(\s*|\d+|[^\w\s]+|\w*\d\w*)$')

[Raj]

@hi2019 
this should work
!REGEX_Match([City],'^(\s*|\d+|[^\w\s]+|\d\w*)$')

[ChrisTX]

This will avoid RegEx, may be easier to understand and maintian:

IF IsEmpty(Trim([f1])) OR
Contains([f1], "0123456789") OR
!Contains([f1], "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",0)
THEN 1
ELSE 0
ENDIF

[hi2019]

Thanks!

What is the best way to learn these? what tool do you use if any?

[cjaneczko]

I typically use www.regexr.com

[ChrisTX · Accepted solution]

regex101.com is also a good website