| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.GetColumn
Queries a column from each line in a list.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.GetColumn"; List; Separator; Column { ; NoReturnEnding } ) More
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)
Example result:
123
456
See also
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
- Neues MBS FileMaker Plugin 11.3
- MBS FileMaker Plugin 11.3 - More than 6500 Functions In One Plugin
- MBS FileMaker Plugin, version 11.3pr1
This function checks for a license.
Created 2nd June 2021, last changed 15th June 2021
