In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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 

 

Please find the updated workflow

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @45134904 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!

45134904
7 - Meteor

CAN YOU ADD COMMA AND FINALIZE THE WORKFLOW

 

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

Here is the updated workflow

 

atcodedog05_0-1646031625764.png

 

Hope this helps : )

 

Please don't forget to mark my replies as solutions since I have solved multiple questions.

45134904
7 - Meteor

for this one can you add comma

 

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

I have added a comma and can you check and let me know what issue you are facing.

 

atcodedog05_0-1646032597946.png

 

Hope this helps : )

 

45134904
7 - Meteor

can you add comma in this work flow

 

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

Please find the updated workflow.

 

Hope this helps : )

Labels
Top Solution Authors