Replace
Abstract
Replace text values in your data.
Replace text values in your data.
Note
Symon.AI only uses Python RegEx.
When to use this tool
Use when you want to replace values in your data.
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 |