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

Reporting

Accepted answers

binu_acs

@hi2019 regex solution

Filter_17072024.yxmd

All comments

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

@hi2019 regex solution

Filter_17072024.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703