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  


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


Parameter Description Example Flags
Text The CSV text. "Hello;World"
Delimiter The delimiter to use.
If empty, we auto detect it.
";" Optional


Returns matrix or error.


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.


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

Blog Entries

This function is free to use.

Created 11st October 2020, last changed 22nd June 2023

Matrix.CSV - Matrix.Clear

💬 Ask a question or report a problem