Searching for letter characters

[London Martin]

Hello FileMakerers,

I'm struggling with the lack of a wildcard symbol specifically for letters as opposed to digits. # represents one digit; @ represents one of any character; but there is no symbol specifically for one alphabetical character.

One example of how I want to apply this is in searching for valid UK postcode formats (I could also use this in the definition of a calcualation field to return 1 or 0 for the postcode field being valid). In Access I would use a string along the lines of

Like "[A-Z][0-9] [0-9][A-Z][A-Z]" Or Like "[A-Z][0-9][0-9] [0-9][A-Z][A-Z]" Or Like "[A-Z][0-9][A-Z] [0-9][A-Z][A-Z]" Or Like "[A-Z][A-Z][0-9] [0-9][A-Z][A-Z]" Or Like "[A-Z][A-Z][0-9][0-9] [0-9][A-Z][A-Z]" Or Like "[A-Z][A-Z][0-9][A-Z] [0-9][A-Z][A-Z]"

In FileMaker, I can use # for [0-9] ; what can I use for [A-Z] ?

Hope someone can enlighten me.

Many thanks,

Martin

[mr_vodka]

Well a range for a letter can be done with entering A..PZZZZ Will find anything that starts with A and ends up to PZZZZ.

However, unlike Access I dont believe that you cant Directly create validation masks or search ranges like that.

However, you can probably do a Test for each individual character being in the format that you want.