| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.CSVSplit
Splits CSV text.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 7.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.CSVSplit"; Text { ; Delimiter } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| Text | The CSV text. | "Hello;World" | |
| Delimiter | Available in MBS FileMaker Plugin 8.5 or newer. The delimiter to use. If empty, we auto detect it. |
";" | Optional |
Result
Returns list 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.
Please note that the parsing can handle multi line values, but that causes the list to have multiple entries for the value. Use Matrix.CSVSplit or QuickList.CSVSplit to handle that better as those can hold multi line values.
Examples
Split with one value:
MBS("List.CSVSplit"; "hello")
Split with three values:
MBS("List.CSVSplit"; "\"hello\";\"test\";\"CSV\"")
Split with 3 rows and 3 values:
MBS("List.CSVSplit"; "\"hello1\";\"test\";\"CSV\"¶\"hello2\";\"test\";\"CSV\"¶\"hello3\";\"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 9.0
- Fixed potential issue for List.CSVSplit function.
- Version 8.5
- Added delimiter parameter for List.CSVSplit, QuickList.CSVSplit and FM.InsertRecordCSV.
- Improved handling of extra quotes in CSV text for List.CSVSplit function.
- Improved List.CSVSplit to handle empty fields better and ignore = before quotes.
- Version 8.0
- Improved CSV split (List.CSVSplit) to handle multi line text values better.
- 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.6pr3
- MBS FileMaker Plugin, version 8.5pr7
- MBS FileMaker Plugin, version 8.5pr4
- MBS FileMaker Plugin, version 8.5pr3
- MBS FileMaker Plugin, version 8.0pr8
- Parsing VCard file
- CSV functions in MBS FileMaker Plugin
- MBS FileMaker Plugin, version 7.4pr8
This function checks for a license.
Created 21st September 2017, last changed 15th July 2022
