In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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 

 

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