Monkeybread Software - MBS FileMaker Plugin: QuickList.DeCombine

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

QuickList.DeCombine

Picks elements from each line in a list.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
List	7.5	Yes	Yes	Yes	Yes	Yes

MBS( "QuickList.DeCombine"; ListRef; ColumnDelimiter; StartColumn; EndColumn { ; ReturnNewList; NoReturnEnding } ) More

Parameters

Parameter Description Example Flags

ListRef The reference to the list returned from QuickList.New function. $List

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

ReturnNewList Pass 1 to return result as new QuickList. This new list must be freed later using QuickList.Free function. Pass 0 (Default) to return a text list. 0 Optional

NoReturnEnding If you passed 0 for ReturnNewList, decides about new list:
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

Parameter	Description	Example	Flags
ListRef	The reference to the list returned from QuickList.New function.	$List
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
ReturnNewList	Pass 1 to return result as new QuickList. This new list must be freed later using QuickList.Free function. Pass 0 (Default) to return a text list.	0	Optional
NoReturnEnding	If you passed 0 for ReturnNewList, decides about new list: 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 new 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

Sort a list column:

Set Variable [ $List ; Value: "65412|Schreiber|Klaus|459oz8235" & ¶ & "76542|Abraham|Hermmann|38957zf" & ¶ & "85112|Behrens|Robert|489748hj" ]
Set Variable [ $QuickList1 ; Value: MBS( "QuickList.New"; $list ) ]
#
Set Variable [ $QuickList2 ; Value: MBS( "QuickList.DeCombine"; $QuickList1; "|"; 1 /* StartColumn*/; 1 /* EndColumn */; 1 /* New List*/ ) ]
Set Variable [ $List2 ; Value: MBS( "QuickList.GetList"; $QuickList2) ]
Set Variable [ $r ; Value: MBS( "QuickList.SortWith"; $QuickList2; 1; $QuickList1 ) ]
Set Variable [ $List1 ; Value: MBS( "QuickList.GetList"; $QuickList1) ]
#
Set Variable [ $r ; Value: MBS( "QuickList.Free"; $QuickList1 ) ]
Set Variable [ $r ; Value: MBS( "QuickList.Free"; $QuickList2 ) ]

Blog Entries

MBS FileMaker Plugin, version 7.5pr1

Release notes

Version 7.5
- Added QuickList.DeCombine function.

Created 29th September 2017, last changed 21st December 2018

QuickList.CrossProduct - QuickList.Deserialize

Feedback: Report problem or ask question.