Skip to main content

Find Replace Tool

Use Find Replace to find a string in 1 column of a dataset and look up and replace it with another string. You can also use Find Replace to append columns to a row.

Tip

This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.

Tool Components

Find Replace Tool Anchors.png

Figure: Find Replace tool with 2 anchors.

The Find Replace tool has 2 anchors:

  • Input anchor: Contains the data to be replaced.

  • Output anchor: The output anchor displays the results of the Find Replace tool.

Configure the Tool

The Find Replace tool configuration is has 3 sections: Lookup Table, Find, and Replace.

Lookup Table

Enter data to be found in the Find Values column. Then, enter the data you want to replace the found values with in the Replace Values column.

Find Section

  1. Column to Search: Select the column in the table with data to be replaced.

  2. Choose the search criteria:

    • Contains: Searches for the instance of the column value in any part of the column. The entire column does not have to only contain what is being searched for.

    • Starts With: Searches for the instance of the column value at the beginning of the column. The entire column does not have to only contain what is being searched for.

    • Exactly Equal To: Searches for the instance of the column value contained within the entire column. The instance has to be there in its entirety to be replaced with the new value.

  3. Select optional search conditions:

    • Case Sensitive: This option includes the case in the search.

    • Match Whole Word Only: Strings are only matched if there are leading and trailing spaces. For strings at the beginning or end of a cell, there must be a space at the other end.

Replace Section

You can choose to replace data using these options:

  • Replace Found Text:

    1. Choose this option to replace the found text with what you've entered in the Lookup Table.

    2. Optionally select Replace All Matched Items. This should only be used if you selected Contains from the first option.

  • Create Columns with Replace Data:

    1. Choose this option to create a column populated with the Lookup Table data whenever the selected Find Values data is found within the selected String Column to Search.

    2. Check the columns you want to create.

In this section: