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?
Solved! Go to Solution.
@binuacs Thank you :)
Hi, @bsanthoshpk
Another regex syntax for you:
IIF(REGEX_CountMatches([Input], '[^[:alnum:]\s,.\-&\/\\]'),'Not OK','OK')