Help Centre › Building Processes
This article describes the RPA Excel functionality to find values using a pattern.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Find values using a pattern function allows you to find values using a pattern.
Setting it up
To use the EXCEL Find values using a pattern function, follow these instructions:
{{popups:rpas/add:action=excel-regex}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Find values using a pattern function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Find values using a pattern option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| From column | Yes | Text | - | The source column name |
| To column | Yes | Text | - | The destination column name |
| Pattern | No | Select | - | A predefined regex pattern (Address, Date, E-mail, IP, etc.) or Other for custom |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
| Column not found | The source column does not exist |
Tips
- Extracts data matching the regex pattern from one column to another
- Available patterns: Address, Date, E-mail, IP, Order number, Time, URL, and more