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

List.DeCombine

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

Parameters

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.
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 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

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"

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