Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 11.0   11.1   11.2   11.3   11.4   11.5   12.0   12.1   12.2   12.3    Statistic    FMM    Blog  


Picks elements from each line in a list.

Component Version macOS Windows Linux Server iOS SDK License
List 6.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes Paid
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

  • Version 12.3
    • Fixed List.DeCombine and QuickList.DeCombine to handle the ReturnNewline parameter correctly.
  • Version 7.5

Blog Entries

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

List.CrossProduct - List.Deserialize

Feedback: Report problem or ask question.

Start Chat