Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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