| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
QuickList.CSVSplit
Splits CSV text.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 7.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "QuickList.CSVSplit"; Text { ; Delimiter } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| Text | The CSV text. | "Hello;World" | |
| Delimiter | The delimiter to use. If empty, we auto detect it. |
";" | Optional Added in version 8.5. |
Result
Returns QuickList reference number or error.
Description
Splits CSV text.Plugin automatically detects if comma or semicolon is used.
Returns list with all values.
Version 8 can detect tab character, too.
Examples
Try with 3 values:
MBS("QuickList.CSVSplit"; "\"hello\";\"test\";\"CSV\"")
See also
Release notes
- Version 12.4
- Fixed a problem with List.CSVSplit, Matrix.CSVSplit and QuickList.CSVSplit not parsing properly quoted multi line value.
- Version 12.2
- Optimized List.CSVSplit, QuickList.CSVSplit and Matrix.CSVSplit to better handle lonely quotes in quoted strings.
- Version 8.5
- Added delimiter parameter for List.CSVSplit, QuickList.CSVSplit and FM.InsertRecordCSV.
- Version 7.4
- Added CSV functions: FM.InsertRecordCSV, List.CSVSplit and QuickList.CSVSplit.
Blog Entries
- MBS FileMaker Plugin, version 12.4pr1
- MBS FileMaker Plugin, version 12.2pr1
- MBS FileMaker Plugin, version 8.5pr3
- CSV functions in MBS FileMaker Plugin
- MBS FileMaker Plugin, version 7.4pr8
This function checks for a license.
Created 21st September 2017, last changed 22nd October 2018
