0

My output in formula field is : [ ref:_5540058J._578sdie5:ref ]

My expected output is :

ref:_5540058J._578sdie5:ref

I tried Trim with Left and Right but it is not giving expected result

  • when you tried trim what did you get. – Tushar Sharma Sep 28 '16 at 10:17
  • I got it by using Mid and length functions -> MID( field__c , 2, LEN(field__c) -2 ) – Prince Sep 28 '16 at 10:25
1

Try below function

TRIM(
LEFT(
    TRIM(
        RIGHT(field__c,  (LEN(field__c) - 1) ) 
        ),
        (LEN(field__c) - 3)
    )
)
| improve this answer | |
1

Following function will also work

TRIM(SUBSTITUTE(SUBSTITUTE(field__c,'[',''),']',''))
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.