At our company has two emails for everyone, one that is just the company name and one that is US.Companyname.com
With part of what I am working on we are searching by the normal email as we are slowly going away from the other. So what I want is to go through the email column and any instance of "US." I want removed so instead of rmartori@us.comp.com it becomes rmartori@comp.com.
