isValidZip ( zip )

used to determine if entered zip is a valid 5 or 9 digit zip code

Be the first to rate this function Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

isValidZip( "00501-2045" )
isValidZip( "00501" )
isValidZip( "00500" )
isValidZip( "1234-56789" )
isValidZip( "oo5o1-2o45" )
isValidZip( "A1234-5678" )

Sample output:

9 //(true)
5 //(true)
0 //(false)
0 //(false)
0 //(false)
0 //(false)

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

/*	Author:		Kyle Williams
	Date:		1/19/2023
	Purpose:		to validate both the format and numerical value of a zip code
	Dependencies:  CF "isNumeric"  ( https://www.briandunning.com/cf/2299 )
	Examples:		isValidZip( "00501-2045" )   = 9
				isValidZip( "00501" ) = 5
				isValidZip( "00500" ) = 0

	Note:	Any value that is not 0 = TRUE so this result is both boolean and 
			can be used to determine the type of valid zip code (if valid) 
*/

Let([
	 is5digitZip = isNumeric ( zip ) and Length ( zip ) = 5
	;is9digitZip = 
		Position ( zip ; "-" ; 1 ; 1 ) = 6 and 
		PatternCount ( zip, "-" ) = 1 and
		Length ( zip ) = 10 and
		isNumeric ( left( zip, 5 )) and
		isNumeric ( right( zip, 4 ))
	;zip5 = 0+left( zip, 5 )
	;valid5zip = isNumeric ( zip5 ) and zip5 > 500 
];
	Case(
		 is5digitZip and valid5zip, 5
		;is9digitZip and valid5zip, 9
		;0
	  )
)

This function is used to determine if the entered zip code is a valid 5 or 9 digit zip code

Comments

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

isValidZip ( zip )

Comments

Support this website.

Support this website.