Find and Replace Activity
The Find and Replace activity enables users to locate a specific word or phrase within an Excel file, text, or other file content. It then replaces all occurrences of the found text with a desired new word or phrase. This activity streamlines data manipulation and content updates across various document types.
| Field | Description | Requirement |
|---|---|---|
| Excel Name | The reference name of the MS Excel file that has already been opened or created. | Required |
| New Dataset Name | The reference name for the new dataset that will be created to store the results. | Required |
| Sheet Name | The name of the specific sheet within the Excel file to perform the operation. If not specified, the activity defaults to the first sheet. | Optional |
| Range | The specific cell range within the Excel sheet from which to fetch data. | Optional |
| Find What | The string or phrase to search for within the specified content. | Required |
| Replace With | The new string or phrase that will replace all occurrences of the "Find What" value. | Required |
Action Types & Examples
Output Dataset
- Format: dataset
- Example Result:
TestDataset
Implementation Examples
Field Setup - Excel Name - New Dataset Name - Sheet Name - Range - Find What - Replace With
Execution Parameters - Excel Name: formatExcel - New Dataset Name: TestDataset - Sheet Name: Sheet1 - Range: A1:C5 - Find What: RPA - Replace With: RobustaRPA
Technical Notes
The Find and Replace activity performs a case-sensitive search by default. For operations on large Excel files or extensive text content, performance may vary. Ensure the specified Excel file is accessible and not locked by other processes before execution. The activity will overwrite existing data in the target dataset if the "New Dataset Name" already exists.