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.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    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:

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

Blog Entries

FileMaker Magazin

Created 11st October 2020, last changed 2nd November 2020


Matrix.CSV - Matrix.Clear

Feedback: Report problem or ask question.



Links
MBS Xojo blog

Start Chat