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: 11.4   11.5   12.0   12.1   12.2   12.3   12.4   12.5   13.0   13.1    Statistic    FMM    Blog  

Matrix.CSV

Queries text of matrix for CSV export.

Component Version macOS Windows Linux Server iOS SDK
Matrix 9.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Matrix.CSV"; MatrixRef { ; firstRow; lastRow; firstCol; lastCol; rowSeparator; colSeparator; flags } )   More

Parameters

Parameter Description Example Flags
MatrixRef The matrix reference number. $matrix
firstRow The index of first row.
Default is 0.
0 Optional
lastRow The index of last row.
Default is Matrix.Height-1.
5 Optional
firstCol The index of first column.
Default is 0.
0 Optional
lastCol The index of last column.
Default is Matrix.Width-1.
6 Optional
rowSeparator The row separator.
Default is CR.
Char(13) Optional
colSeparator The column separator.
Default is semicolon.
";" Optional
flags Available in MBS FileMaker Plugin 13.0 or newer.
Various flags.
1: Pass 1 to put all text values in quotes.
2: Include colun names in first row (new in v13.1).
0 Optional

Result

Returns text or error.

Description

Queries text of matrix for CSV export.
You can use this method to quickly get all values in a given area as text.
If needed, the plugin puts values in quotes and escape quotes and newlines.

Please use Text.WriteTextFile to write to text file if you need CSV export.

Examples

Show matrix in dialog as CSV:

Show Custom Dialog [ “The Matrix" ; MBS( "Matrix.CSV"; $matrix; 0; 2; 0; 2; Char(13); " " ) ]

See also

Release notes

Example Databases

Blog Entries

This function checks for a paid license.

Created 8th April 2019, last changed 5th February 2023


Matrix.Avg - Matrix.CSVSplit

💬 Ask a question or report a problem


Start Chat