function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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!!