Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Find and replace string within a data set

JeniferReid1
6 - Meteoroid

Hello, 

 

I have a simple workflow that outputs an Excel file that contains the fields "Name" and "Email address". For some of the email addresses I need to correct the domain listed in the address from "@in.gmail.com" to "@gmail.com". I tried using the Find and Replace tool but the configuration asks for a second dataset to replace the data. I don't have a second data set - I just find the email addresses that are incorrect and update them. Does anyone know how I can do this?

 

Jenifer

2 REPLIES 2
fmvizcaino
16 - Nebula
16 - Nebula

Hi @JeniferReid1 ,

 

Use a formula tool instead.

You can use something like this. 

 

Replace(Email, 'in.gmail', 'gmail')

 

 

Best,

Fernando V.

Qiu
18 - Pollux

@JeniferReid1 
I think you mean something like this.

0115-JeniferReid1-A.PNG0115-JeniferReid1-B.PNG

Labels