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 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

45134904
7 - Meteor

input1 -- xyz2578/  ugh-

input2- gdsjhgd,& hfgf ?

 

correct output : input 1

error :input 2 as ? mark is there

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645603108347.png

 

Hope this helps : )

 

45134904
7 - Meteor

I need only these things - alpha, numeric, blanks, hyphen, apostrophe, ampersand, comma, parentheses, period, slash and back slash

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

Please find the updated let me know if you are facing any issues.

 

Hope this helps : )

45134904
7 - Meteor

45134904_0-1645605741812.png

see when I add another hypen its shows as well asapostrophe

 

45134904
7 - Meteor

in my data if hypen and apostrophe is presnet its fine

atcodedog05
22 - Nova
22 - Nova

Hi @45134904 

 

Can you check with this one

 

atcodedog05_0-1645605985808.png

 

Hope this helps : )

 

45134904
7 - Meteor

I need

full stop also

Labels