QuickList.GetColumn
-------------------

Queries a column from each line in a list.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [List](component_List.md) | [11.3](newinversion113.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "QuickList.GetColumn"; List; Separator; Column { ; ReturnNewList } ) 

**MBS**( **"QuickList.GetColumn";** /\* Queries a column from each line in a list. \*/  
**$List**; /\* The reference to the quicklist. \*/   
**$Separator**; /\* The separator text.  
Can be multiple characters.  
For tab separated text, pass Char(9). For CSV separated text, pass ";" or ",".e.g. Char(9) \*/   
**$Column**; /\* The index of the column to compare.  
Starts with 0 for first column.e.g. 0 \*/   
**$ReturnNewList**) /\* Optional; Pass 1 to return result as new QuickList.   
This new list must be freed later using [QuickList.Release](QuickListRelease.md) function. Pass 0 (Default) to modify the list in the List parameter.e.g. 0 \*/ 

### 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](QuickListRelease.md) function. Pass 0 (Default) to modify the list in the List parameter. | 0 | Optional |

### Result

Returns list, OK or error.

### Description

Queries a column from each line in a list.  
### Examples

Try it:

 Let (\[  
// new list  
list = MBS ("[QuickList.New](QuickListNew.md)"; "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](QuickListGetList.md)"; col);  
// and free both lists  
f = MBS ( "[QuickList.Release](QuickListRelease.md)"; list);  
f = MBS ( "[QuickList.Release](QuickListRelease.md)"; col)  
\]; r )  
<small>  
Example result:   
123  
456</small>### See also

- [List.GetColumn](ListGetColumn.md)
- [QuickList.AndColumn](QuickListAndColumn.md)
- [QuickList.DeleteColumn](QuickListDeleteColumn.md)
- [QuickList.GetValue](QuickListGetValue.md)
- [QuickList.New](QuickListNew.md)
- [QuickList.NotColumn](QuickListNotColumn.md)
- [QuickList.OrColumn](QuickListOrColumn.md)
- [QuickList.Release](QuickListRelease.md)
- [QuickList.SetValue](QuickListSetValue.md)
- [QuickList.XOrColumn](QuickListXOrColumn.md)

### Release notes

- **Version 11.3**
    - Added [List.GetColumn](https://www.mbsplugins.eu/ListGetColumn.shtml) and [QuickList.GetColumn](https://www.mbsplugins.eu/QuickListGetColumn.shtml) functions to extract a column from a list.

### Blog Entries

- [New in MBS FileMaker Plugin 11.3](https://www.mbsplugins.de/archive/2021-07-27/New_in_MBS_FileMaker_Plugin_11/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 11.3pr1](https://www.mbsplugins.de/archive/2021-06-03/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

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

  
[QuickList.FindUnequals](QuickListFindUnequals.md) - [QuickList.GetList](QuickListGetList.md)

[HTML Version](QuickListGetColumn.shtml)