Modifying regex to accept comma's?

[Simon Lloyd]

Also posted here: 'VBA Express Forum'
(http://www.vbaexpress.com/forum/showthread.php?t=27363)

Hi all i'm using regex (provided for me by some one else because i
don't have the foggiest with it) to force an entry of letters (at least
for the first two, rather than all numeric, however i want the user to
be able to enter the data in this fashion xxxxxx, xxxxxx where x will be
a character, however, using this ^[a-z]{2}[a-z ]*$ does not allow the
comma, can someone help modify it to accept it?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Ron Rosenfeld]

Also posted here: 'VBA Express Forum'
(http://www.vbaexpress.com/forum/showthread.php?t=27363)

Hi all i'm using regex (provided for me by some one else because i
don't have the foggiest with it) to force an entry of letters (at least
for the first two, rather than all numeric, however i want the user to
be able to enter the data in this fashion xxxxxx, xxxxxx where x will be
a character, however, using this ^[a-z]{2}[a-z ]*$ does not allow the
comma, can someone help modify it to accept it?

From what you've presented, your regex only matches strings with start with two
lower case letters, and continues with only lower case letters or spaces. It
does not match numbers at all and, unless you have set your regex function to
ignore case, it will not match upper case letters either.

If you want to add the ability to also match commas, after the first two lower
case letters, then just add a comma to the second character class:

^[a-z]{2}[,a-z ]*$

If you want something different, you will have to be more specific.
--ron

 

[Simon Lloyd]

Thanks for the reply, i did want a mix of upper and lowercase, and yes i
did want to force the first two characters to be letters and i do not
want numbers at all, should it look like this for mixed
^[Aa-Zz]{2}[,Aa-Zz ]*$

Also posted here: 'VBA Express Forum'
('VBA Express Forum' (http://www.vbaexpress.com/forum/showthread.php?t=27363))

Hi all i'm using regex (provided for me by some one else because i
don't have the foggiest with it) to force an entry of letters (at least
for the first two, rather than all numeric, however i want the user to
be able to enter the data in this fashion xxxxxx, xxxxxx where x will be
a character, however, using this ^[a-z]{2}[a-z ]*$ does not allow the
comma, can someone help modify it to accept it?

From what you've presented, your regex only matches strings with start
with two
lower case letters, and continues with only lower case letters or
spaces. It
does not match numbers at all and, unless you have set your regex
function to
ignore case, it will not match upper case letters either.

If you want to add the ability to also match commas, after the first
two lower
case letters, then just add a comma to the second character class:

^[a-z]{2}[,a-z ]*$

If you want something different, you will have to be more specific.
--ron

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Simon Lloyd]

Thanks for the reply, i did want a mix of upper and lowercase, and yes i
did want to force the first two characters to be letters and i do not
want numbers at all, should it look like this for mixed
^[Aa-Zz]{2}[,Aa-Zz ]*$Aha!, got it with some playing around!

^[A-Za-z]{2}[,A-Za-z ]*$


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Ron Rosenfeld]

Aha!, got it with some playing around!
^[A-Za-z]{2}[,A-Za-z ]*$

That should work.

Here are some links you may find useful (if they are still good )

Regular Expressions
http://www.regular-expressions.info/reference.html
http://support.microsoft.com/default.aspx?scid=kb;en-us;818802&Product=vbb
http://msdn2.microsoft.com/en-us/library/6wzad2b2.aspx
http://msdn2.microsoft.com/en-us/library/ms974619.aspx
http://www.regex-guru.info/
--ron

 

[Simon Lloyd]

Aha!, got it with some playing around!
^[A-Za-z]{2}[,A-Za-z ]*$

That should work.

Here are some links you may find useful (if they are still good )

Regular Expressions
'Regular Expressions Reference - Basic Syntax'
(http://www.regular-expressions.info/reference.html)
'How To Use Regular Expressions in Microsoft Visual Basic 6.0'
(http://tinyurl.com/kwem2c)
'Introduction to Regular Expressions (Scripting)'
(http://msdn2.microsoft.com/en-us/library/6wzad2b2.aspx)
'What's New in Windows Script 5.5'
(http://msdn2.microsoft.com/en-us/library/ms974619.aspx)
'Regex Guru' (http://www.regex-guru.info/)
--ron

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)