isUUID ( uuidString )

Test if input string is a uuid

Average rating: 1.0 (1 vote) Log in to vote

Jonni™ - Show more from this author

Sample input:

isUUID ( "EC3C6323-3079-4937-A873-4448CF075150" )

Sample output:

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

Let (
 
	[ 

		~uuid = Filter ( uuidString ; "abcdef0123456789-" ) ; // uuid string
		~subbed = Substitute ( ~uuid ; "-" ; "¶" ) ; // split char groups into 5 lines
		~t1 = If ( Length ( GetValue ( ~subbed ; 1 ) ) = 8 ; True ; False ) ; // group 1 should be 8 chars
		~t2 = If ( Length ( GetValue ( ~subbed ; 2 ) ) = 4 ; True ; False ) ; // group 2 should be 4 chars
		~t3 = If ( Length ( GetValue ( ~subbed ; 3 ) ) = 4 ; True ; False ) ; // group 3 should be 4 chars
		~t4 = If ( Length ( GetValue ( ~subbed ; 4 ) ) = 4 ; True ; False ) ; // group 4 should be 4 chars
		~t5 = If ( Length ( GetValue ( ~subbed ; 5 ) ) = 12 ; True ; False ) ; // group 5 should be 12 chars
		~ts = If ( PatternCount ( ~uuid ; "-" ) = 4 ; True ; False ) // number of separation markers should be 4 chars

	] ;

		
		If ( ~t1 + ~t2 + ~t3 + ~t4 + ~t5 + ~ts = 6 ; True ; False ) 

)

// Written by: jonni@me.com
// V 1.0

Test if input string is a uuid. Returns 1 if True and 0 if False.

Comments

		Mike Aug 16, 2024
This function equals 1, even if an invalid character was entered. Example: If "uuidString" contains the letter "m", the result is still 1. "m" is not allowed in UUIDs. There is already a function that takes care of this: https://www.briandunning.com/cf/1684

		Jonni™ Sep 24, 2024
Thanks Mike. I didn't know about the disdain for the letter M nor had I been able to find the other function. Appreciate the feedback and the link.

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

isUUID ( uuidString )

Comments

Support this website.

Support this website.