We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Identifying special characters

bsanthoshpk
8 - Asteroid

Hi All,

 

Hope all are doing good.

 

bsanthoshpk_0-1682531695159.png

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?

3 REPLIES 3
binuacs
21 - Polaris

@bsanthoshpk One way of doing this with the Regex_Match function

binuacs_0-1682532525226.png

 

bsanthoshpk
8 - Asteroid

@binuacs Thank you :) 

flying008
15 - Aurora

Hi, @bsanthoshpk 

 

Another regex syntax for you: 

 

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

flying008_0-1682578474535.png

 

Labels
Top Solution Authors