How to exclude spaces when using ValidationExpression in vb.net

Question

I want to exclude spaces when validating a textbox in vb.net. Here is the current ValidationExpressopn value:

ValidationExpression="^([a-zA-Z0-9_-.\']+)@(([[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.)|(([a-zA-Z0-9-]+.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(]?)$" />

When user inputs space in textbox, I dont want that to render as error.

Example: I include spaces after "1@test.com "

This should not be treater as incorrect data in the textbox.

Any ideas?

score 0 · Accepted Answer · edited May 23 '17 at 11:48

0

If your spaces are leading or trailing you can do a Trim on the expressionToValidate before comparing to your regexp

Dim expressionWithoutTrailingAndLeadingWhiteSpaces As String = originalExpression.Trim()

If you want to modify the regExp to take into account the trailing spaces:

^[_a-z0-9-]+(.[a-z0-9-]+)@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,4})( *)$

If you want to exclude also leading spaces add an extra ( *) at the beginning of the expression:

^( *)[_a-z0-9-]+(.[a-z0-9-]+)@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,4})( *)$

Btw - the regExp you are providing is broken - I used the one found here (expression to validate email addresses)

edited May 23 '17 at 11:48

Community

answered Mar 26 '12 at 07:03

Ando

Is it possible to just include the validation inside the "ValidationExpression" in ascx? – JADE Mar 26 '12 at 07:20
Modified the reqExp directly to take into account trailing spaces – Ando Mar 26 '12 at 10:23
Thanks for the info. How about leading spaces? Is it possible to exclude those as well? – JADE Mar 27 '12 at 07:38
I modified the reg exp to include leading spaces - have fun – Ando Mar 27 '12 at 08:02

1 Answers1