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:
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
13.5
Statistic
FMM
Blog
Matrix.CSVSplit
Splits CSV text.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Matrix | 10.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Matrix.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 |
Result
Returns matrix or error.
Description
Splits CSV text.Plugin automatically detects if tab, comma or semicolon is used.
Returns new matrix with all values.
Width is defined by first row.
Please call Matrix.Release later to free the matrix object.
Examples
Test it by sparsing and putting back to CSV:
Let ([
matrix = MBS( "Matrix.CSVSplit"; "FirstName;LastName;City¶Joe;Miller;Las Vegas¶Bob;\"Johnson-Meyer\";\"Köln\"");
text = MBS("Matrix.CSV"; matrix);
r = MBS("Matrix.Release"; matrix)
]; text )
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 10.5
- Added Matrix.CSVSplit function.
Blog Entries
- CSV in FileMaker with MBS FileMaker Plugin
- MBS FileMaker Plugin, version 12.4pr1
- MBS FileMaker Plugin, version 12.2pr1
- New in MBS FileMaker Plugin 10.5
- Import CSV with Matrix functions
- Neues MBS FileMaker Plugin 10.5 - Über 6400 Funktionen in einem Plugin
- MBS FileMaker Plugin 10.5 - More than 6400 Functions In One Plugin
- MBS FileMaker Plugin, version 10.5pr4
FileMaker Magazin
This function is free to use.
Created 11st October 2020, last changed 22nd June 2023
