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