ConcatValues ( listA ; listB ; separator )

Quick and dirty recursive concatenation of two valueLists.

Average rating: 3.5 (2 votes) Log in to vote

Richard Dyce - Show more from this author
Dyce & Sons Ltd.
http://dyce.com

Sample input:

ConcatValues ( "1¶2¶3¶4¶5¶6¶7¶8¶9" ; "A¶B¶C¶D¶E¶F" ; "_" )

Sample output:

"1_A¶2_B¶3_C¶4_D¶5_E¶6_F¶7¶8¶9"

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

/*
ConcatValues ( listA ; listB ; separator )
Quick and dirty recursive concatenation of two valueLists.

e.g.

ConcatValues (  "1¶2¶3¶4¶5¶6¶7¶8¶9" ; "A¶B¶C¶D¶E¶F" ; "_" ) = "1_A¶2_B¶3_C¶4_D¶5_E¶6_F¶7¶8¶9"

*/

Case(
	ValueCount( listA ) = 0 ; listB ;
	ValueCount( listB ) = 0 ; listA ;
	List( GetValue ( listA ; 1 ) & separator & GetValue ( listB ; 1 ) ; ConcatValues( MiddleValues ( listA ; 2 ; 100000 ) ; MiddleValues ( listB ; 2 ; 100000 ) ; separator ) )
)

This is just a quick and dirty solution, until someone comes up with a non-recursive one. Works well for lists up to 1,000 certainly.

Comments

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

ConcatValues ( listA ; listB ; separator )

Comments

Support this website.

Support this website.