The "Find and replace" instruction is used to find and replace values in an Excel spreadsheet.
How to configure the step
The instruction is quite intuitive to create and use.
After adding an action step for to manipulate data, simply select "Find and replace" out of the available Excel instructions.
You will then be presented with the following configuration view for the "Find and replace" instruction.
1. First, you will need to select the desired target range in your indicated Excel workbook.
2. Next, you will then need to select the data type of the value you wish to find, followed by the actual value
3. Lastly, you will need to indicate whether the value you wish to replace with is static or dynamic.
A static replacement value is one that does not change across different process runs. In other words, the value you want to replace with will be the same every single time you run this process. In this case, simply select "Literal" and type in the desired value.
A dynamic replacement value, on the other hand, is a value that can potentially change across different process runs. This can be done by linking the value to a separate data step property, since data step properties can be dynamically updated in process runs (such as in the "Publish cell value" instruction). In this case, select "Input/Output of another step" and a pop-up window will appear that will allow you to navigate and find the desired data step property.