I have data which is in this format:
J 123 K

([JjXxZz]\s)?\d{3}\s[A-Za-z]

Just an idea. My thoughts might be to limit the search by including "^" and
"$"

"^([JjXxZz]\s)?\d{3}\s[A-Za-z]$"

What I'm thinking is that maybe something like
"A 123 k" might test True by ignoring the "A",
and
"ABC j 123 k" might test True by finding the pattern within a larger
string.

--
Dana DeLouis
Windows XP & Office 2007


"Ron Rosenfeld" wrote in message
...
On 29 Apr 2007 06:55:01 -0700, wrote:

I have data which is in this format:

J 123 K

The J is optional, could be upper or lower case, and could be a J or
an X or a Z.

It is always followed by a space. The three digits. Then a space.
Then any alphabetic character upper or lower case, but not optional,
the character must be there.

([JjXxZz]\s)?\d{3}\s[A-Za-z]




I am having trouble with the pattern, could someone show me how to set
it up?

tia
bob

--ron