Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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