How Do I Avoid Special Characters In A Field...

Question

0.00/5 (No votes)

See more:

Hi,
How do i prevent typing special characters in a field.

i tryed:

VB

NOT(REGEX(Phone,
"\\D*?(\\d\\D*?)"))

but then i cant put spaces in space should be allowed.

can anybody help me please?

Thank you
#regards
Seb.

Posted 8-Dec-14 22:21pm

Member 11296931

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Unihedron · Answer 1 · 2014-12-12T20:05:00

Solution 3

You can use this regex:

PERL

/[\w ]+/

This will allow word characters and spaces.

Posted 12-Dec-14 20:05pm

Unihedron

Maciej Los · Answer 2 · 2014-12-08T22:51:00

Solution 1

A universal regex pattern for this task does not exists. It's set of reason[^].

Have a look here: http://www.regexlib.com/DisplayPatterns.aspx?cattabindex=6&categoryId=7[^] and choose the proper one for you.

Posted 8-Dec-14 22:51pm

Maciej Los

OriginalGriff · Answer 3 · 2014-12-08T22:55:00

"\D" means "any character that isn't a digit", and "\d" means "any character that is a digit" so your regex is:

Any character that is not a digit, any number of repetitions, as few as possible
A numbered capture group. [\d\D*?]
    \d\D*?
        Any digit
        Any character that is not a digit, any number of repetitions, as few as possible

Which is a little odd for a phone number, which is what you appear to be trying to match - because it will match anything that has a digit in it...
The "normal" phone number regex is along the lines of:

\((?<areacode>\d{3})\)\s*(?<number>\d{3}(?:-|\s*)\d{4})</number></areacode>

And it might be worth your starting there and working out how to match exactly what you are after.

To help you in this, get a copy of Expresso [^] - it's free, and it examines and generates Regular expressions.
It's where I got the explanation of your regex, and the sample phone number one from.