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
Jay Parikh 36Jay Parikh 36 

Formula Fields

ONE TEXT FEILD AND FIELD NAME CALLED   PROFILE HAS VALEUES OF  John - 78, Jorden - 71, Detra - 67, Fees - 65
1. NEW FORMULA FIELD output >>> John
2. NEW FORMULA FIELD output >>>78
3. NEW FORMULA FIELD output >>>Jorden
4. NEW FORMULA FIELD output >>>71
5. NEW FORMULA FIELD output >>>Detra
6. NEW FORMULA FIELD output >>> 67
7. NEW FORMULA FIELD output >>> Fees
7. NEW FORMULA FIELD output >>> 65
Arvind KumarArvind Kumar
Hi Jay,
Your question is not clear. 
Could you explain your question?

Thanks,
Arvind Kumar
Maharajan CMaharajan C
Hi Jay,

Please use the below formulas in your fromula field. So that you can get the expected result.

Th o/p for john - 78 will be in 

TRIM(LEFT(PROFILE , FIND(" -", PROFILE))) >>> john
RIGHT(fPROFILE,LEN(PROFILE) - FIND("- ", PROFILE)  ) >>> 78

Can you please let ne know the my answer will be help ful to you if it means then choose this as the best answer!!!

Thanks,
RAJ C
Jay Parikh 36Jay Parikh 36
what about the rest of things??Jorden - 71, Detra - 67, Fees - 65
i need that output also ???