jGetMask ( string )
Will return the 'mask' of a string
Average rating: 4.7 (17 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Will return the 'mask' of the string sent to it. The mask will contain:
'S' for a Space ' '
'9' for any number
'A' for any character (upper or lower case)
'P' for any character other than detailed above
Used to assist in resolving badly formed UK postcodes
WC1A 1AZ -> AA9AS9AA
S8 SEW -> A9SAAA
Y011 OSN -> A9AASAAA
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.