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