Apex Code Development You need to sign in to do that
Don't have an account?
Eric Fortenberry How can I create a field that equals another field but truncates everything after '-'?
I would like to add a field to our Accounts that equals the account name up until there is a dash '-'. We do not want anything after the dash to be in this new field. How can I do that? I've created a new custom field, but am not sure how to write the formula to accomplish this. Thanks for the help!
You might want this instead:
if(contains(Name,"-"),LEFT(Name, FIND("-", Name) - 1),Name)
All Answers
Figured this part out.
LEFT(Name, FIND("-", Name) - 1)You might want this instead:
if(contains(Name,"-"),LEFT(Name, FIND("-", Name) - 1),Name)