Find and replace

“Find and replace” activity is used to find a specific word or phrase within an Excel file, text, or file and then replace it with a desired word or phrase.


* Excel name	The reference name of the Excel file which has already been opened or created is chosen in the dropdown.
*New dataset name	Reference name of dataset which will be created
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.
Range	Excel sheet range from which to fetch data is written.
*Find what	String that is searched for and will be replaced.
*Replace with	New string that will be replaced with.

Note: * Fields selected with are required, others are optional.

Excel name example

You can use the Excel name as shown in the example.

${formatExcel}

New dataset name

You can use the New dataset name as shown in the example.

TestDataset

Sheet name example

You can use the Sheet name as shown in the example.

Sheet1

Range example

You can use the Range as shown in the example.

A1:C5

Find what example

You can use the Find what as shown in the example.

RPA

Replace with examples

You can use the Replace with as shown in the example .

RobustaRPA