Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2   9.3   9.4    Statistic  

Matrix.CSV

Queries text of matrix for CSV export.

Component Version macOS Windows Server FileMaker Cloud 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 value
MatrixRef The matrix reference number. $matrix
firstRow Optional
The index of first row.
Default is 0.
0
lastRow Optional
The index of last row.
Default is Matrix.Height-1.
5
firstCol Optional
The index of first column.
Default is 0.
0
lastCol Optional
The index of last column.
Default is Matrix.Width-1.
6
rowSeparator Optional
The row separator.
Default is CR.
Char(13)
colSeparator Optional
The column separator.
Default is semicolon.
";"

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.

See also

Blog Entries

Created 8th April 2019, last changed 8th April 2019


Matrix.Avg   -   Matrix.Clear

Feedback: Report problem or ask question.




Links
MBS FileMaker blog