Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.5   8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2    Statistic  


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 } )   More


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.
EndColumn Index of column to end.
First is 0. If you only want one column, please pass same value for start and end column.
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.


Returns list or error.


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


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"

See also

Blog Entries

Created 25th June 2016, last changed 11st December 2016

List.CrossProduct   -   List.Deserialize

Feedback: Report problem or ask question.

MBS Xojo Plugins