Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.0   6.1   6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3    Statistic  

List.DeCombine

Picks elements from each line in a list.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
List 6.3 Yes Yes Yes Yes Yes

MBS( "List.DeCombine"; List; ColumnDelimiter; StartColumn; EndColumn { ; NoReturnEnding } )

Parameters

Parameter Description Example value
List The list to process. "Hello" ¶ "" ¶ "World"
ColumnDelimiter The delimiter between colums.
This is also used in result.
"|"
StartColumn Index of column to start.
First is 0.
0
EndColumn Index of column to end.
First is 0. If you only want one column, please pass same value for start and end column.
0
NoReturnEnding Optional
Pass 1 to have no extra newline character on the end of the returned list. Default is 0 to include one to easily concat lists.
1

Result

Returns list or error.

Description

Picks elements from each line in a list.
This function combines values from a list by picking only given columns.

Examples

Queries second word in each entry:

MBS( "List.DeCombine"; "Hello|The|World¶Thats|What|WeMake¶YUPP|Thats|Fun"; "|"; 1; 1 ;1 )

Example result: "The¶What¶Thats"

Query fist word in each entry:

MBS( "List.DeCombine"; "Hello|The|World¶Thats|What|WeMake¶YUPP|Thats|Fun"; "|"; 0; 0 ;1 )

Example result: "Hello¶Thats¶YUPP"

Query first adn second word in each entry:

MBS( "List.DeCombine"; "Hello|The|World¶Thats|What|WeMake¶YUPP|Thats|Fun"; "|"; 0; 1 ;1 )

Example result: "Hello|The¶Thats|What¶YUPP|Thats"


List.CrossProduct   -   List.Deserialize

Feedback: Report problem or ask question.




Links
MBS FileMaker Plugins