QuickList.DeCombine
-------------------

Picks elements from each line in a list.

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

MBS( "QuickList.DeCombine"; ListRef; ColumnDelimiter; StartColumn; EndColumn { ; ReturnNewList; NoReturnEnding } ) 

**MBS**( **"QuickList.DeCombine";** /\* Picks elements from each line in a list. \*/  
**$ListRef**; /\* The reference to the list returned from [QuickList.New](QuickListNew.md) function.e.g. $List \*/   
**$ColumnDelimiter**; /\* The delimiter between colums.  
This is also used in result.e.g. "|" \*/   
**$StartColumn**; /\* Index of column to start.  
First is 0.e.g. 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.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 return a text list.e.g. 0 \*/   
**$NoReturnEnding**) /\* Optional; If you passed 0 for ReturnNewList, decides about new list:  
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 |
|---|---|---|---|
| ListRef | The reference to the list returned from [QuickList.New](QuickListNew.md) function. | $List |  |
| 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 |  |
| 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 return a text list. | 0 | Optional |
| NoReturnEnding | If you passed 0 for ReturnNewList, decides about new list:   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 new 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

Sort a list column:

 Set Variable \[ $List ; Value: "65412|Schreiber|Klaus|459oz8235" &amp; ¶ &amp; "76542|Abraham|Hermmann|38957zf" &amp; ¶ &amp; "85112|Behrens|Robert|489748hj" \]   
Set Variable \[ $QuickList1 ; Value: MBS ( "[QuickList.New](QuickListNew.md)"; $list ) \]   
\#   
Set Variable \[ $QuickList2 ; Value: MBS ( "QuickList.DeCombine"; $QuickList1 ; "|"; 1 /\* StartColumn\*/; 1 /\* EndColumn \*/; 1 /\* New List\*/ ) \]   
Set Variable \[ $List2 ; Value: MBS ( "[QuickList.GetList](QuickListGetList.md)"; $QuickList2 ) \]   
Set Variable \[ $r ; Value: MBS ( "[QuickList.SortWith](QuickListSortWith.md)"; $QuickList2 ; 1; $QuickList1 ) \]   
Set Variable \[ $List1 ; Value: MBS ( "[QuickList.GetList](QuickListGetList.md)"; $QuickList1 ) \]   
\#   
Set Variable \[ $r ; Value: MBS ( "[QuickList.Release](QuickListRelease.md)"; $QuickList1 ) \]   
Set Variable \[ $r ; Value: MBS ( "[QuickList.Release](QuickListRelease.md)"; $QuickList2 ) \]  
### See also

- [List.DeCombine](ListDeCombine.md)
- [List.Sort](ListSort.md)
- [QuickList.GetList](QuickListGetList.md)
- [QuickList.New](QuickListNew.md)
- [QuickList.Release](QuickListRelease.md)
- [QuickList.Sort](QuickListSort.md)
- [QuickList.SortWith](QuickListSortWith.md)

### Release notes

- **Version 12.3**
    - Fixed [List.DeCombine](https://www.mbsplugins.eu/ListDeCombine.shtml) and [QuickList.DeCombine](https://www.mbsplugins.eu/QuickListDeCombine.shtml) to handle the ReturnNewline parameter correctly.
- **Version 7.5**
    - Added [QuickList.DeCombine](http://www.mbsplugins.eu/QuickListDeCombine.shtml) function.

### Blog Entries

- [MBS FileMaker Plugin, version 12.3pr1](https://www.mbsplugins.de/archive/2022-06-02/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 7.5pr1](https://www.mbsplugins.de/archive/2017-10-01/MBS_FileMaker_Plugin_version_7/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 29th September 2017 , last changed 14th December 2023

  
[QuickList.CrossProduct](QuickListCrossProduct.md) - [QuickList.DeleteColumn](QuickListDeleteColumn.md)

[HTML Version](QuickListDeCombine.shtml)