filter or formula help

[hi2019]

Hi,

I need a formula or filter to do this 

if OWNER-CITY field is null, only spaces, contains a number, or is only a symbol(s) 

I need to pull out to manual tab

PLEASE HELP

thanks

[LindonB]

Try something like this. Let me know if it helps or you have questions.

IF IsNull([owner-city]) OR
Trim([owner-city]) = "" OR
REGEX_Match([owner-city], ".*\\d.*") OR
REGEX_Match([owner-city], "^[^a-zA-Z]*$")
THEN [owner-city]
ELSE Null()
ENDIF

[binu_acs · Accepted solution]

@hi2019 regex solution