QuickList.GetColumn

Queries a column from each line in a list.

Parameters

Parameter	Description	Example	Flags
List	The reference to the quicklist.	$List
Separator	The separator text. Can be multiple characters. For tab separated text, pass Char(9). For CSV separated text, pass ";" or ",".	Char(9)
Column	The index of the column to compare. Starts with 0 for first column.	0
ReturnNewList	Pass 1 to return result as new QuickList. This new list must be freed later using QuickList.Release function. Pass 0 (Default) to modify the list in the List parameter.	0	Optional

Result

Returns list, OK or error.

Description

Examples

Try it:

Let ([
// new list
list = MBS("QuickList.New"; "Hello,123,abc¶World,456,def");
// query the column and copy to new list
col = MBS( "QuickList.GetColumn"; list; ","; 1; 1);
// now get text from list
r = MBS( "QuickList.GetList"; col);
// and free both lists
f = MBS( "QuickList.Release"; list);
f = MBS( "QuickList.Release"; col)
]; r )

Example result:
123
456

See also

• List.GetColumn
• QuickList.AndColumn
• QuickList.GetList
• QuickList.GetValue
• QuickList.New
• QuickList.NotColumn
• QuickList.OrColumn
• QuickList.Release
• QuickList.SetValue
• QuickList.XOrColumn

Release notes

• Version 11.3
  • Added List.GetColumn and QuickList.GetColumn functions to extract a column from a list.

Blog Entries

• New in MBS FileMaker Plugin 11.3
• MBS FileMaker Plugin, version 11.3pr1

This function checks for a license.

Created 2nd June 2021, last changed 14th December 2023

QuickList.FindUnequals - QuickList.GetList