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 ]*$
Ron Rosenfeld;395256 Wrote:
On Fri, 26 Jun 2009 07:20:40 +0100, Simon Lloyd
wrote:


Also posted he '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's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=110364