This is just for my own notes because I use this code infrequently and don’t like to retype it. If you need to update an email field and change the domain, use this code:
Mid([contactpoint],1,InStr(1,[contactpoint],”@”))+”finished_domain.com”
Make sure you’re only selecting the data you wish to update.