Replace
Replace text values in your data.
Replace text values in your data.
Add multiple operations or conditions when you configure the Replace tool. However, you cannot use the same column with search type and find in different conditions if replace is different.
You can also use the drag and drop icon 
to order your operations the way you want.
Note
If you select RegEx as the search type, Varicent ELT only uses Python RegEx.
When to use this tool
Use when you want to replace values in your data.
Usage example
In this example, we have two values in the VoicemailPlan column that mean the same thing.
CustomerID | VoicemailPlan |
|---|---|
32131 | Y |
75674 | Yes |
44344 | Yes |
32424 | Y |
Let's clean this up so we have consistent values.
In the Target Columns field, select or type VoicemailPlan.
For Search Type, select Exact Match.
In the Find field, type Yes.
In the Replace field, type Y.
As a result, the data set now looks like this:
CustomerID | VoicemailPlan |
|---|---|
32131 | Y |
75674 | Y |
44344 | Y |
32424 | Y |