Matrix.GetRow
-------------

Queries text of a whole row.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [Matrix](component_Matrix.md) | [9.2](newinversion92.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "Matrix.GetRow"; MatrixRef; Row { ; NewLineReplacement } ) 

**MBS**( **"Matrix.GetRow";** /\* Queries text of a whole row. \*/  
**$MatrixRef**; /\* The matrix reference number.e.g. $matrix \*/   
**$Row**; /\* The zero based row number.e.g. 2 \*/   
**$NewLineReplacement**) /\* Optional; The replacement text for newline characters.e.g. ", " \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| MatrixRef | The matrix reference number. | $matrix |  |
| Row | The zero based row number. | 2 |  |
| NewLineReplacement | The replacement text for newline characters. | ", " | Optional |

### Result

Returns list or error.

### Description

Queries text of a whole row.  
Returns list of values.  
### Examples

Queries row values:

 Set Variable \[ $row ; Value: MBS ("Matrix.getRow"; $Matrix ;0) \]  
Query columns and rows with replacing new line characters:

 # query a few fields in a table   
Set Variable \[ $m ; Value: MBS ( "[Matrix.NewWithSQL](MatrixNewWithSQL.md)"; ""; "SELECT Vorname, Comment FROM Kontakte" ) \]   
\#   
\# query columns and rows and replace new lines   
Set Variable \[ $col1 ; Value: MBS ( "[Matrix.GetColumn](MatrixGetColumn.md)"; $m ; 0; "-") \]   
Set Variable \[ $col2 ; Value: MBS ( "[Matrix.GetColumn](MatrixGetColumn.md)"; $m ; 1; "-") \]   
Set Variable \[ $row1 ; Value: MBS ( "Matrix.GetRow"; $m ; 0; "-") \]   
\#   
\# show results   
Show Custom Dialog \[ "First Column" ; $col1 \]   
Show Custom Dialog \[ "Second column" ; $col2 \]   
Show Custom Dialog \[ "First Row" ; $row1 \]   
Set Variable \[ $r ; Value: MBS ( "[Matrix.Release](MatrixRelease.md)"; $m ) \]  
### See also

- [Matrix.AddRow](MatrixAddRow.md)
- [Matrix.GetColumn](MatrixGetColumn.md)
- [Matrix.GetRowNames](MatrixGetRowNames.md)
- [Matrix.GetValue](MatrixGetValue.md)
- [Matrix.New](MatrixNew.md)
- [Matrix.NewWithSQL](MatrixNewWithSQL.md)
- [Matrix.Release](MatrixRelease.md)
- [Matrix.SetColumnNames](MatrixSetColumnNames.md)
- [Matrix.SetRow](MatrixSetRow.md)
- [Matrix.SetRowName](MatrixSetRowName.md)

### Release notes

- **Version 12.2**
    - Added new parameter to replace new lines in the list with replacement text for [Matrix.GetColumn](https://www.mbsplugins.eu/MatrixGetColumn.shtml), [Matrix.GetRow](https://www.mbsplugins.eu/MatrixGetRow.shtml) and [Matrix.GetText](https://www.mbsplugins.eu/MatrixGetText.shtml) functions.

### Blog Entries

- [CSV in FileMaker with MBS FileMaker Plugin](https://www.mbsplugins.de/archive/2022-10-11/CSV_in_FileMaker_with_MBS_File/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 12.2pr5](https://www.mbsplugins.de/archive/2022-05-04/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [Import CSV with Matrix functions](https://www.mbsplugins.de/archive/2020-11-20/Import_CSV_with_Matrix_functio/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 8th April 2019 , last changed 9th October 2022

  
[Matrix.GetColumnNames](MatrixGetColumnNames.md) - [Matrix.GetRowName](MatrixGetRowName.md)

[HTML Version](MatrixGetRow.shtml)