| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.DeCombine
Picks elements from each line in a list.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 6.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.DeCombine"; List; ColumnDelimiter; StartColumn; EndColumn { ; NoReturnEnding } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| List | The list to process. | "Hello" ¶ "" ¶ "World" | |
| 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 | |
| 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
Picks elements from each line in a list.This function combines values from a list by picking only given columns.
Examples
Queries second word in each entry:
MBS( "List.DeCombine"; "Hello|The|World¶Thats|What|WeMake¶YUPP|Thats|Fun"; "|"; 1; 1 ;1 )
Example result: "The¶What¶Thats"
Query fist word in each entry:
MBS( "List.DeCombine"; "Hello|The|World¶Thats|What|WeMake¶YUPP|Thats|Fun"; "|"; 0; 0 ;1 )
Example result: "Hello¶Thats¶YUPP"
Query first adn second word in each entry:
MBS( "List.DeCombine"; "Hello|The|World¶Thats|What|WeMake¶YUPP|Thats|Fun"; "|"; 0; 1 ;1 )
Example result: "Hello|The¶Thats|What¶YUPP|Thats"
See also
Release notes
- Version 12.3
- Fixed List.DeCombine and QuickList.DeCombine to handle the ReturnNewline parameter correctly.
- Version 7.5
- Added QuickList.DeCombine function.
- Fixed problem in List.DeCombine not returning list with first empty element missing.
Blog Entries
- MBS FileMaker Plugin, version 12.3pr1
- MBS FileMaker Plugin, version 7.5pr2
- MBS FileMaker Plugin, version 6.3pr5
This function checks for a license.
Created 25th June 2016, last changed 11st December 2016
