Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


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