CombineLists ( list1 ; list2 ; startposition ; separator )

concatenates one List to another

Average rating: 4.6 (23 votes) Log in to vote

Oscar Bautista
Richard Carlton Consutling
http://www.rcconsulting.com

Sample input:

CombineLists ( "1¶2¶3" ;"a¶b¶c" ; 2; "~" )

Sample output:

2~b
3~c

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

/*
* =====================================
* Purpose:    To concatenate two list
* Parameters: list1
*             list2
*             startpoint
*             separator
* Author:     Oscar Bautista
*
*
* =====================================
*/

Let ( [
	~l1 = list1 
;	~l2 = list2
;	~c =  startposition
;	~s = separator
] 
;	 Case ( 
		~c =  ValueCount( ~l1 ) +1 
	;		""
	;	GetValue(~l1;~c) & ~s & GetValue(~l2;~c) & ¶ & CombineLists(~l1;~l2; ~c+1;~s  ))
	)

This recursive function creates a list made up of two. with a separator and a starting position.

Comments

		J. Montana, Chuburna Sep 3, 2015
Should the second parameter not be "list2" ? CombineLists ( list1 ; list2 ; startposition; separator )

		Oscar, Oscar Sep 3, 2015
Fixed it thanks

		Bruce, Redmond WA Sep 4, 2015
Your example text is incorrect ( misplaced quote marks). Should be: CombineLists ( "1Â¶2Â¶3" ; "aÂ¶bÂ¶c" ; 2; "~" ) Note also there is another custom function listed here with the same name.

		Bruce, Redmond WA Sep 4, 2015
I find this easier to read: Case ( startposition = ValueCount( list1 ) +1 ; "" ; GetValue( list1; startposition) & separator & GetValue( list2 ; startposition ) & Â¶ & CombineLists ( list1 ; list2 ; startposition+1; separator ) )

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

CombineLists ( list1 ; list2 ; startposition ; separator )

Comments

Support this website.

Support this website.