CombineLists ( )

Function stats

Average user rating
509
387
9999
Support
FileMaker 7.0 +
Date posted
04 September 2015
Version
1
Recursive function
Yes

Author Info
 Oscar.B1

1 functions

Average Rating None

author_avatar



 

Function overview

Prototype

CombineLists  ( list1;   list2;   startposition;   separator )


Parameters

list1  


list2  


startposition  where in the lists to start


separator  


Description

Tags:  List   groups   Concatenate   combine  

concatenates two lists

Examples

Sample input

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


Sample output

2~b
3~c

 

Function code

/*
* =====================================
* Purpose: To concatinate 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 function is published on FileMaker Custom Functions
    to check for updates and provide feedback and bug reports
    please visit http://www.fmfunctions.com/fid/387

    Prototype: CombineLists( list1; list2; startposition; separator )
    Function Author: Oscar.B1 (http://www.fmfunctions.com/mid/509)
    Last updated: 04 September 2015
    Version: 1

*/
// ===================================

 

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (31)
Date  (28)
XML  (26)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)
Interface  (15)
Layout  (15)
Text  (14)
Variables  (12)
Layout Objects  (11)
Filter  (11)
Design  (10)
Array  (7)