Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
10.5
11.0
11.1
11.2
11.3
11.4
11.5
12.0
12.1
12.2
Statistic
FMM
Blog
List.CSVSplit
Splits CSV text.
Component | Version | macOS | Windows | Linux | Server | iOS SDK | License |
List | 7.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | Paid |
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.
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.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.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
Created 21st September 2017, last changed 22nd October 2018
List.BestMatch - List.CountValues
Feedback: Report problem or ask question.
