Find and replace string within a data set

[JeniferReid1]

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

[fmvizcaino]

Hi @JeniferReid1 ,

Use a formula tool instead.

You can use something like this. 

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

Best,

Fernando V.

[Qiu]

@JeniferReid1 
I think you mean something like this.