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.
Tool Components
The Find Replace tool has 3 anchors:
F input anchor: This input is the initial input table ("F" for "Find"). This is the table that is updated in the tool's results.
R input anchor: This input is the lookup table ("R" for "Replace"). This is the table that contains data used to replace data in (or append data to) the initial input.
Output anchor: The output anchor displays the results of the Find Replace tool.