+ Start a Discussion
Chad RitchieChad Ritchie 

Formula Question regarding Trimming

Hey guys, I'm trying to figure out a formula that will only pull the first name of an email. So for example, pull "Chad" out of chad.c.ritchie@gggcorporation.com, but I also would need this to work for jonathan.n.reed@gggcorporation.com, so I imagine it is something to do with extracting values to the left of the furthest period, but I'm not sure how to do it. Here is what I have right now which isn't working:                      trim(left( Contact.Email ,find(".", Contact.Email ,1)-1))

Thank you!!