ArrayCombine ( array1 ; array2 ; startposition ; separator )

Returns a combined array from two separate arrays, similar to php's array_combine function.

Average rating: 4.7 (3 votes) Log in to vote

Julio Toledo - Show more from this author
Automation USA LLC
https://www.automationusa.net

Sample input:

array1 = "x¶y¶z"
array2 = "2¶4¶8"
startposition = "2"
separator = ": "

Sample output:

y: 4
z: 8

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

/*
 * =====================================================
 * ArrayCombine ( array1 ; array2 ; startposition ; separator )
 * 
 * PARAMETERS:
 *		array1 = Return separated values
 *		array2 = Return separated values
 *		startposition = numerical index of which value to start from
 *		separator = separator string (any length)
 *
 * RETURNS:
 *		Returns a combined array from two separate arrays, similar to php's array_combine function.
 *		Use in conjunction with ArrayReformat function (http://www.briandunning.com/cf/2033) to create custom syntax name-value pairs, including JSON
 *
 *		Examples: 
 *
 *				Let ( [
 *
 *					list1 = ArrayReformat ( "Label1¶Label2¶Label3¶Label4" ; "\"" ; "null" ; "¶" ; "" ) ;
 *					list2 = ArrayReformat ( "fantastic!¶...but what about¶a syntax for adding¶an element to the END of an array?" ; "\"" ; "null" ; "¶" )
 *					] ; 
 *
 *					//calculation
 *					ArrayReformat ( ArrayCombine ( list1 ; list2 ; 1 ; " : " ; "" ) ; "{}" ; "[]" ; " , " )
 *				)
 *
 *				Returns the following JSON —> [{"Label1" : "fantastic!"} , {"Label2" : "...but what about"} , {"Label3" : "a syntax for adding"} , {"Label4" : "an element to the END of an array?"}]
 *
 *
 * DEPENDENCIES:
 * 		None
 *
 * NOTES:
 * 		Recursive function
 *
 * RELEASE:
 * 		2017-05-04 - Initial release by Julio Toledo
 * 		2017-05-05 - Function renamed by Julio Toledo from "CombineArrays" to "ArrayCombine"
 * =====================================================
 * 
 */

Let ( [ 
combination = 
		Case ( 
			startposition = ValueCount( array1 ) +1 ; "" ; 
			GetValue( array1; startposition) & separator & GetValue( array2 ; startposition ) & ¶ & ArrayCombine ( array1 ; array2 ; startposition +1 ; separator )
		) 
] ;

combination

)

Yet another recursive function for combining two value lists (return separated arrays).

Comments

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

ArrayCombine ( array1 ; array2 ; startposition ; separator )

Comments

Support this website.

Support this website.