Alteryx designer Discussions

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

Find & Replace Help

Highlighted
5 - Atom

Hi - I've been trying to use the F&R tool to basically remove the "ie" from a list of user emails but it doesn't seem to be working - as you can see I start off with data in column B and I want to make it look like column C - simple I;m sure - any ideas??

Highlighted
15 - Aurora

Can you repost your Input data and expected outcome. This is what's in the file you attached.

 

Team nameEmail
Johnny O'Neiljohnny'neil@ie.voda.com
Ciara Dolanciara dolan@voda.com
Andrew Macguireandrew macguire@voda.com
Emmet Baxteremmet baxter@voda.com

 

The format of the replace function would be. 

 

Replace([Email],"ie.","") 

 

if that is what you want to do.

Highlighted
11 - Bolide

Hi Ciara,

 

This solution assumes that 'ie.' always shows up right after the '@' in the email string.

Therefore, try Replace([Email], '@ie.', '@')...attached.

 

Please let me know if you need anything else.

Btw, column C on your attached file is blank

 

Fix_EmailString.PNG

Labels