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.5   10.0   10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2    Statistic    FMM    Blog  

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 } )   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 FM.SQL.RowCount-1.
5 Optional
firstCol The index of first column.
Default is 0.
0 Optional
lastCol The index of last column.
Default is FM.SQL.FieldCount-1.
6 Optional
rowSeparator The row separator.
Default is CR.
Char(13) Optional
colSeparator The column separator.
Default is tab character.
Char(9) 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

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


Matrix.Sum - Matrix.Width

Feedback: Report problem or ask question.