ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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
Météore

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 RÉPONSES 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
Météore

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
Météore

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
Météore

45134904_0-1645605741812.png

see when I add another hypen its shows as well asapostrophe

 

45134904
Météore

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
Météore

I need

full stop also

Étiquettes
Auteurs des meilleures solutions