WrapAllValuesInList ( theList ; prefix ; suffix )

Appends a prefix and a suffix to every value in a given list

Be the first to rate this function Log in to vote

Ethan - Show more from this author
Tactile Medical
https://www.linkedin.com/in/ethyoder

Sample input:

WrapAllValuesInList ( List ( 1 ; 2 ; 3 ) ; "root.key[" ; "]" )

Sample output:

root.key[1]
root.key[2]
root.key[3]

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

//	Name		WrapAllValuesInList
//
//	Parameters	theList (list): the list you want modified
//			prefix (text): the prefix you want to add to every value in the list
//			suffix (text): the suffix you want to add to every value in the list
//
//	Description	Appends a prefix and a suffix to every value in a given list
//
//	Dependencies	<<none>>
//
//	2022-02-16, eyoder [Tactile Medical], Created custom function


Let ([
	vList = theList ;
	vPrefix = prefix ;
	vSuffix = suffix ;

	vValue = vPrefix & Substitute ( vList ; ¶ ; vSuffix  & ¶ & vPrefix ) & vSuffix 
];

	vValue

)

The function takes in a list, prefix, and suffix, and appends the prefix and suffix to every value in the list.

Comments

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

WrapAllValuesInList ( theList ; prefix ; suffix )

Comments

Support this website.

Support this website.