Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data Validation to check character type in string field - letter ,number and punctuation

45134904
7 - Meteor

I need help from some one please to quickly point out the most elegant way to validate a field based on its char type. I want to validate that my field contains only  alpha, numeric, blanks, hyphen, apostrophe, ampersand, comma, parentheses, period, slash and back slash. 

 

if the field contains any other punctuation I want it to fail the test. 

 

Thanks

27 REPLIES 27
atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

It works on that too take a look

 

atcodedog05_0-1645607753962.png

 

Hope this helps : )

 

45134904
7 - Meteor

45134904_0-1645607748048.png

 I want dot as all matches pop up

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

Found the issue fixed it.

 

atcodedog05_0-1645607866410.png

 

Hope this helps : )

 

45134904
7 - Meteor

45134904_0-1645607963038.png

see in second row dot also poopping

 

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

check the last response found the issue and fixed it.

 

Hope this helps : )

45134904
7 - Meteor

thanks this one is working. one more scenario I have can you please help

 

valid characters are Alpha, Hyphens, Parentheses, Periods and Apostrophes.
and Forward slash is allowed only as part of the special sequence N/A.

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

Here is the workflow. When you say alpha is number also included ?

 

atcodedog05_0-1645613979612.png

 

Hope this helps : )

 

45134904
7 - Meteor

alpha is only alphabet, not number

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645614345410.png

 

Hope this helps : )

 

45134904
7 - Meteor

Can you please add space

Labels
Top Solution Authors