Apex Code Development You need to sign in to do that
Don't have an account?
pmozz01 Formula Field Help
I am trying to create a formula field that takes a text field and only displays the values after the hyphen. For example, the text field contains XXX XX-ZZZ ZZZZ. I only want the values ZZZ ZZZZ and want to remove the hyphen and everything before it. This is the formula I have tried but it does not find the hyphen"
TRIM(RIGHT(Owning_Org__c, FIND("-",Owning_Org__c)))
What this formula gives me is: XX-ZZZ ZZZZ. To complicate this further, the text is not the same length after or before the hyphen. Any ideas on how to accomplish would be much appreciated!!!
Thanks!!!! Works perfectly :)
All Answers
Right( Owning_Org__c , (len(Owning_Org__c) - FIND('-', Owning_Org__c)))
This should do the trick.
Thanks!!!! Works perfectly :)
No problem