Newest functions Upload a function Leave a tip My account

There are 2,577 functions in this library.

jGetMask ( string )

Will return the 'mask' of a string

  Average rating: 4.7 (17 votes) Log in to vote

John Buckingham - Show more from this author microGuidance http://microguidance.co.uk

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* Custom Function: jGetMask ( string ) John Buckingham, microGuidance, 2016 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 Examples: WC1A 1AZ -> AA9AS9AA S8 SEW -> A9SAAA Y011 OSN -> A999SAAA */ Let ( [ t = Left ( string ; 1 ) ; c = Case ( Filter ( t ; " " ) = t ; "S" ; Filter ( t ; "0123456789" ) = t ; "9" ; Filter ( Upper ( t ) ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) = t ; "A" ; "P" ) ] ; If ( Length ( string ) > 0 ; c & jGetMask ( Right ( string ; Length ( string ) - 1 ) ) ) ) Click to copy

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

Examples:
WC1A 1AZ -> AA9AS9AA
S8 SEW -> A9SAAA
Y011 OSN -> A9AASAAA

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: