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
Matrix.CSVSplit
Splits CSV text.
Component | Version | macOS | Windows | Linux | Server | iOS SDK | License |
Matrix | 10.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | Free |
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:
SetzeVar ([
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.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
- 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
Created 11st October 2020, last changed 2nd November 2020
Feedback: Report problem or ask question.
