Brian Dunning's FileMaker Custom Functions

ConcatValues ( listA ; listB ; separator )

Quick and dirty recursive concatenation of two valueLists.

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

Richard Dyce   Richard Dyce
Dyce & Sons LTD.
http://dyce.com

Share on Facebook Share on Twitter

  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)

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

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.