Data Validation to check character type in string field - letter ,number and punctuation
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
input1 -- xyz2578/ ugh-
input2- gdsjhgd,& hfgf ?
correct output : input 1
error :input 2 as ? mark is there
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need only these things - alpha, numeric, blanks, hyphen, apostrophe, ampersand, comma, parentheses, period, slash and back slash
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
see when I add another hypen its shows as well asapostrophe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
in my data if hypen and apostrophe is presnet its fine
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need
full stop also
