You need to sign in to do that
Don't have an account?
Meli Perron
I'm trying to build a formula that does the same thing as this RegEx function: (.+?).[a-z]{2,63}$
I want to strip out anything to the right of the first "." in a website or email so that navy.mil.jp would output only navy
How can I do this in Salesforce since RegEx cannot be used to create a formula field?
How can I do this in Salesforce since RegEx cannot be used to create a formula field?
Can you please check if below formula works.
If this solution helps, Please mark it as best answer.
Thanks,
All Answers
Can you please try the below formula and check if it is useful.
If this solution helps, Please mark it as best answer.
Thanks,
Hi Sai Praveen. That formula didn't work. Email was milo@sargento.com.jp, and your formula output mili@sargento.
can you get rid of everything except "sargento"?
Can you please check if below formula works.
If this solution helps, Please mark it as best answer.
Thanks,