Skip to main content

Symon.AI help center

Replace

Replace text values in your data.

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.

  1. In the Target Columns field, select or type VoicemailPlan.

  2. For Search Type, select Exact Match.

  3. In the Find field, type Yes.

  4. 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