What should be in {a-Z}?

Hello,

Would you please tell me {a-Z} includes all of letters?

such a,b,c,…xyz and A,B,C…XYZ?

Can I use the formula below for zip code validation?

@If(@Matches(@ThisValue; “{a-Z}{0-9}{a-Z}”); @Success; “You must enter letters like k1p”)

Thanks,

Linda

Subject: what should be in {a-Z}?

Try either one of these:

@If(@Matches(@ThisValue; “{A-Za-z}{0-9}{A-Za-z}”); @Success; “You must enter letters like k1p”)

@If(@Matches(@LowerCase(@ThisValue); “{a-z}{0-9}{a-z}”); @Success; “You must enter letters like k1p”)

Subject: RE: what should be in {a-Z}?

Thanks Ben and Cesar. I got it.

Linda

Subject: what should be in {a-Z}?

As you can see in the partial ASCII chart below, this is a fairly meaningless range. You would be closer with {A-z}, but you should really use {A-Za-z} which matches anything in the set {A-Z} or {a-Z} according to the help document for @Matches which gives the example:

{A­FL­R}

Matches any character in the sets A…F and L…R