CombineValues ( list1 ; list2 )
Combines two lists of values, sort of like php's array_combine function
Average rating: 4.4 (39 votes) Log in to vote
Jonathan Stark Consulting
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
CombineValues can be used to mimic the behavior of creating an associate array in php. List1 becomes the "Keys" and List2 becomes the "Vals".
I wrote it to be used in conjunction with a Let statement, wrapped in an Evaluate statement to parse incoming script parameters into local script variables.
With minor mods, you can alter the delimiters and output format to suit your taste - I left it really generic.
Tom Vincent, Nearly Normal Services
May 6, 2011
Simple, elegant, just the thing I'd have come up with after seven or eight rewrites and a couple of late nights. (We may have similar coding esthetics.)
And embarrassingly, I only needed it for a Tool Tip.
Dec 10, 2014
|Fantastic! Was in a bind with this one when I found it. Many thanks|
Adam Dempsey, UK
Jul 10, 2018
I've tweaked this slightly, adding a delim param (I wanted a space) and fixed it adding an extra line return at the end.
CombineValues ( list1 ; list2 ; delim )
( ValueCount( list1 ) = 0 ) or ( ValueCount( list2 ) = 0 );
GetValue( list1; 1 ) & delim & GetValue( list2; 1 ) &
Length( GetValue( list1; 2 ) ) > 0 and
Length( GetValue( list2; 2 ) ) > 0;
RightValues( list1; ValueCount( list1 ) - 1 );
RightValues( list2; ValueCount( list2 ) - 1 );
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.