# Get Row Col By Text

This is a pre-built action available under the **Captured Grid Element** from the **SAP GUI Application**. The functionality of this action in Avo Assure is to find the row number and column number of a cell that contains specific text in a Grid in SAP application and save the result in the dynamic variable.  

### Syntax 

**Input Value:** `<InputText>`

| Argument                             | Description                                |
| ------------------------------------ | ------------------------------------------ |
| <p>\<InputText></p><p>(Required)</p> | Enter the text to be searched in the Grid. |

**Output Value**&#x20;

| Argument                                  | Description                                                      |
| ----------------------------------------- | ---------------------------------------------------------------- |
| <p>Dynamic Variable</p><p>(Required) </p> | This variable stores the row and column number                   |
| <p>Dynamic Variable</p><p>(Optional) </p> | This dynamic variable holds the result as **True** or **False**. |

&#x20;**Example**&#x20;

**Finds the row and column number of a cell containing the specified text in the SAP Grid**

The **GetRowColByText** action takes the input text from the Input Value column **(e.g., 15.11.2019)** and searches for it in the SAP Grid. If found, the row and column position of the matching cell **(e.g., \[\['2','4'], \['8','4']\['14','4']])** is stored in the **{RowColNum}** variable

<figure><img src="https://2174257472-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8QZzXZMIJSStKAzDSTu%2Fuploads%2FuiLNSxF9MUpbFf3mtWxg%2Fimage.png?alt=media&#x26;token=05844c25-ca33-4b68-b01b-d70f6b69e285" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2174257472-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8QZzXZMIJSStKAzDSTu%2Fuploads%2FTbjybaA0jWESFsLzPtjz%2Fimage.png?alt=media&#x26;token=d9c67a5b-de66-444f-b387-4b6c16b57f3b" alt=""><figcaption></figcaption></figure>