List.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( "List.GetColumn"; List; Separator; Column { ; NoReturnEnding } ) 

**MBS**( **"List.GetColumn";** /\* Queries a column from each line in a list. \*/  
**$List**; /\* The list.e.g. "Hello" ¶ "World" \*/   
**$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 \*/   
**$NoReturnEnding**) /\* Optional; 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.e.g. 1 \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| List | The list. | "Hello" ¶ "World" |  |
| 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 |  |
| 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

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

Query middle column:

 MBS ( "List.GetColumn"; "Hello,123,abc¶World,456,def"; ","; 1)  
<small>  
Example result:   
123  
456</small>### See also

- [List.AndColumn](ListAndColumn.md)
- [List.DeleteColumn](ListDeleteColumn.md)
- [List.NotColumn](ListNotColumn.md)
- [List.OrColumn](ListOrColumn.md)
- [List.XOrColumn](ListXOrColumn.md)
- [QuickList.GetColumn](QuickListGetColumn.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)
- [Neues MBS FileMaker Plugin 11.3](https://www.mbsplugins.de/archive/2021-07-12/Neues_MBS_FileMaker_Plugin_113/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin 11.3 - More than 6500 Functions In One Plugin](https://www.mbsplugins.de/archive/2021-07-12/MBS_FileMaker_Plugin_113_-_Mor/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 15th June 2021

  
[List.FindUnequals](ListFindUnequals.md) - [List.GetValue](ListGetValue.md)

[HTML Version](ListGetColumn.shtml)