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: 9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5    Statistic    FMM    Blog  

Matrix.CSVSplit

Splits CSV text.

Component Version macOS Windows Server FileMaker Cloud FileMaker 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.Free 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.Free"; matrix)

]; text )

See also

Release notes

  • Version 10.5
    • Added Matrix.CSVSplit function.

Created 11st October 2020, last changed 11st October 2020


Matrix.CSV   -   Matrix.Clear

Feedback: Report problem or ask question.



Links
MBS FileMaker Plugins