Find and Replace

Overview:

The Find/Replace data action block allows you to automatically search for specific values in your data fields or table columns and replace them with new values. You can apply this action to one or more fields, update the original field, or create a new one with the replaced values.

Steps to Set Up Find/Replace Data Action Block:

1. Access Workflow:

   • Navigate to the 'Workflow' section from the left panel on your Nanonets Extract Data page.

2. Add Data Action Block:

   • Click on “Add a new step” to view all available data action blocks.
   • From the list, select "Find and Replace".

   

3. Select Fields:

   • Choose one or more fields (flat fields or table columns) where you want to apply the find-and-replace operation.

   

4. Find Value:

   • Enter the value you want to search for in the selected fields.

   

5. Replace Value:

   • Enter the new value to replace the searched value in the selected fields.

   

6. Output Settings:

   • Decide whether to update the existing field or create a new one:

     • Choose "Show in original field" to replace the value within the same column or field.

     

     • Choose "Show in new field" to create a new column or field with the replaced value. If selected, provide a label name for the new field.

       

7. Test the Action:

   • Use the "Test Action" option to select the uploaded file and test the configuration.

   

8. Complete Setup:

   • Once the configuration is complete and you've successfully tested the block, click on the "Done" button to save the data action.

   

   
   

You can apply this data action conditionally, using the Conditional Block.