In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

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
17 - Castor
17 - Castor

Hi @JeniferReid1 ,

 

Use a formula tool instead.

You can use something like this. 

 

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

 

 

Best,

Fernando V.

Qiu
21 - Polaris
21 - Polaris

@JeniferReid1 
I think you mean something like this.

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

Labels
Top Solution Authors