Brian Dunning's FileMaker Custom Functions

CombineLists ( list1 ; list2 ; startposition ; separator )

concatenates one List to another

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

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

Share on Facebook Share on Twitter

  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)

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

 

Comments

J. Montana   J. Montana, Chuburna
Sep 3, 2015
Should the second parameter not be "list2" ?

CombineLists ( list1 ; list2 ; startposition; separator )
 
oscar   oscar, Santa Clara
Sep 3, 2015
Fixed it thanks
 
Bruce   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   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 )
)
 

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.