Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Picks elements from each line in a list.

Component Version macOS Windows Linux Server iOS SDK
List 6.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "List.DeCombine"; List; ColumnDelimiter; StartColumn; EndColumn { ; NoReturnEnding } )   More


Parameter Description Example Flags
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 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 Optional


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

Release notes

Blog Entries

This function checks for a license.

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

List.CrossProduct - List.Deserialize