Data Validation to check character type in string field - letter ,number and punctuation

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

Expression

Accepted answers

All comments

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 : )

input1 -- xyz2578/ ugh-

input2- gdsjhgd,& hfgf ?

correct output : input 1

error :input 2 as ? mark is there

Here is how you can do it.

Workflow:

Hope this helps : )

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

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

Hope this helps : )

see when I add another hypen its shows as well asapostrophe

in my data if hypen and apostrophe is presnet its fine

Can you check with this one

Hope this helps : )

I need

full stop also

It works on that too take a look

Hope this helps : )

I want dot as all matches pop up

Found the issue fixed it.

Hope this helps : )

see in second row dot also poopping

check the last response found the issue and fixed it.

Hope this helps : )

thanks this one is working. one more scenario I have can you please help

valid characters are Alpha, Hyphens, Parentheses, Periods and Apostrophes.
and Forward slash is allowed only as part of the special sequence N/A.

Here is the workflow. When you say alpha is number also included ?

Hope this helps : )

Duplicate (1).yxmd

alpha is only alphabet, not number

Here is how you can do it.

Workflow:

Hope this helps : )

Can you please add space

Please find the updated workflow

Hope this helps : )

CAN YOU ADD COMMA AND FINALIZE THE WORKFLOW

Here is the updated workflow

Hope this helps : )

Please don't forget to mark my replies as solutions since I have solved multiple questions.

can you add comma in this work flow

Please find the updated workflow.

Hope this helps : )

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703