Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

Matrix.Text

Queries text of matrix.

Component Version macOS Windows Linux Server iOS SDK
Matrix 9.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Matrix.Text"; 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.
Can be more than one character.
Char(13) Optional
colSeparator The column separator.
Default is tab character.
Can be more than one character.
Char(9) Optional
flags Available in MBS FileMaker Plugin 13.1 or newer.
Various flags.
2: Include colun names in first row.
0 Optional

Result

Returns text or error.

Description

Queries text of matrix.
You can use this method to quickly get all values in a given area as text.
This joins the values and removes text formatting.

See also

Release notes

Blog Entries

This function checks for a license.

Created 8th April 2019, last changed 31st March 2023


Matrix.Sum - Matrix.Width