I’d like to strip the domain from the email address. It can be done with RIGHT, LEN, and FIND in Excel but I’m having trouble translating it to Airtable. Can anyone help?
Jeremy_Chevallier:
REPLACE({Email},1,FIND("~",SUBSTITUTE({Email},"@","~",LEN({Email}) - LEN(SUBSTITUTE({Email},"@","")))),"")
Thanks for that Jeremy!!! You rock!