Find and Replace Activity
The Find and Replace activity enables users to locate a specific word or phrase within an Excel file, text, or a general file. It then replaces the identified text with a new, desired word or phrase. This activity supports operations across various document types.
| Field | Description | Requirement |
|---|---|---|
| Excel Name | The reference name of the Excel file which has already been opened or created is chosen in the dropdown. | Required |
| New Dataset Name | Reference name of the dataset which will be created to store the modified content. | Required |
| Sheet Name | The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default. | Optional |
| Range | Excel sheet range from which to fetch data is written. | Optional |
| Find What | String that is searched for and will be replaced. | Required |
| Replace With | New string that will be replaced with. | Required |
Action Types & Examples
New Dataset Creation
- Format: Dataset (containing modified content)
- Example Result:
TestDataset
Implementation Examples
Field Setup - Excel name: ${formatExcel} - New dataset name: TestDataset - Sheet name: Sheet1 - Range: A1:C5 - Find what: RPA - Replace with: RobustaRPA
Execution Parameters - (No specific execution parameters provided in the raw input.)
Technical Notes
The Find and Replace activity operates on the specified target (Excel, text, or file) and creates a new dataset for modified Excel content. Users should ensure appropriate permissions for file access and consider the impact on large datasets. The activity performs a direct string match for replacement.