| 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 column 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
- Dictionary.ToMatrix
- Matrix.Evaluate
- Matrix.GetText
- Matrix.Height
- Matrix.List
- Matrix.Rotate
- Matrix.Width
Release notes
- Version 14.4
- Fixed a bug with Matrix.Text function where it would skip some columns if they were constants in SQL used to create the matrix.
- Version 13.1
- Added flags parameter to Matrix.Text function and a flag for Matrix.CSV and Matrix.Text to include column names in first row.
Blog Entries
This function checks for a license.
Created 8th April 2019, last changed 7th June 2024
