It looks like the match function is too "greedy" when matching ".*" and ".+", especially when it is followed by a negative pattern ("[^...]" ). Match ( "abc@", "^.*[@]$" ) matches correctly but match ( "abc@", "^.*[^@]$" ) also returns true when it shouldn't. Match ( "abc@", "^.*[x]$" ) on the other hand correctly returns false. The function just isn't implemented correctly.

Andreas is correct.

If you look at the 11th and 13th sample patterns in the Help document URL you referenced in your question, you'll see:

^[^a-z]$    Matches any single character string that is not a lowercase character

which is almost what you want, and:

^[0-9]+$    Matches any string containing only digits.

If you replace the contents inside the square brackets from the 13th sample pattern (0-9) with the contents of the square brackets from the 11th sample pattern (^a-z), you get:

^[^a-z]+$    Matches any string that does not contain a lowercase character

which is what Andreas has recommended.

HTH, John

Hi.

Why you need the dots (.) and the asterisks (*)? An expression like:

if match("abc", "^[^a-z]+$") then
   messagebox("", "Doesn't contains lower case chars")
else
   messagebox("", "Contains lower case chars")
end if

should be enough.

Andreas.