How to remove section of an email address?

Question

john.smith@pc.test.commike.j.lee@pc.test.com

I have a list of email address in the above format.  I want to remove the pc. from all the emails but I don't want this to apply to anything before the @.  So the output for above should be:

john.smith@test.commike.j.lee@test.com

DataNath · Accepted Answer

Hey @richleeb2 - you can use the Replace() function to clean up these email addresses. In the Formula tool expression, I've made the target string a little more specific by including the @ sign, just in case you ever get an email where .pc. is part of the name (as you can see in the 3rd, extra example I've included just to demonstrate, this won't be removed):

Replace([Email], '@pc.', '@')