Monkeybread Software - MBS FileMaker Plugin: Matrix.CSV

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.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

Matrix.CSV

Queries text of matrix for CSV export.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
Matrix	9.2	Yes	Yes	Yes	Yes	Yes

MBS( "Matrix.CSV"; MatrixRef { ; firstRow; lastRow; firstCol; lastCol; rowSeparator; colSeparator } ) 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

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

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, we put values in quotes and escape quotes and newlines.

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