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: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

List.DeCombine

Picks elements from each line in a list.

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

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

• QuickList.DeCombine
• QuickList.SortWith

Blog Entries

• MBS FileMaker Plugin, version 7.5pr2
• MBS FileMaker Plugin, version 6.3pr5

Release notes

• Version 7.5
  • Added QuickList.DeCombine function.
  • Fixed problem in List.DeCombine not returning list with first empty element missing.

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

List.CrossProduct   -   List.Deserialize

Feedback: Report problem or ask question.