PhoneFormatList ( PhoneList )

Formats all of the phone numbers in a list of phone numbers

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:

PhoneFormatList ( "2061234567" & ¶ & "(425)8675309" )

Sample output:

(206) 123-4567
(425) 867-5309

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

//Dependent on my other CF "PhoneFormat"

Case 
( 
	IsEmpty ( PhoneList ) ; PhoneList ; 
	Let
	(
		[
			Input = GetValue ( PhoneList ; 1 ) ;
			 
			Output = 
				PhoneFormat ( input )
		] ; 

		Output 
		&
		Case 
		( 
			ValueCount ( PhoneList ) > 1 ; "¶" ; 
			"" 
		)  
		& 
		PhoneFormatList ( RightValues ( PhoneList ; ValueCount ( PhoneList ) - 1 ) )

	)

)

This Function Utilizes my other function "PhoneFormat" to format all of the phone numbers in a list.

Comments

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

PhoneFormatList ( PhoneList )

Comments

Support this website.

Support this website.