Identifying special characters

[bsanthoshpk]

Hi All,

Hope all are doing good.

Question: Any line with spl characters should be flagged as 'Not Ok' with few exemptions " , . - & \ / " 

thus here line 7 and line 6 are flagged as "Ok" as they have / and - 

Where as line 2 etc are flagged as 'Not Ok'

Long story short: Spl characters not allowed except " , . - & / \ "

Can you guys help how to achieve this in alteryx?

[binuacs · Accepted solution]

@bsanthoshpk One way of doing this with the Regex_Match function

[bsanthoshpk]

@binuacs Thank you :) 

[flying008]

Hi, @bsanthoshpk 

Another regex syntax for you: 

IIF(REGEX_CountMatches([Input], '[^[:alnum:]\s,.\-&\/\\]'),'Not OK','OK')