Remove first and Last character from string In Formula field

Question

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

I got it by using Mid and length functions -> MID( field__c , 2, LEN(field__c) -2 ) — Prince, Commented Sep 28, 2016 at 10:25

Himanshu · Accepted Answer · 2016-09-28 10:32:44Z

1

Following function will also work

TRIM(SUBSTITUTE(SUBSTITUTE(field__c,'[',''),']',''))

answered Sep 28, 2016 at 10:32

Himanshu

10.5k5 gold badges20 silver badges33 bronze badges

Add a comment |

fred · Accepted Answer · 2023-08-22 14:18:42Z

1

Try below function

TRIM(
    LEFT(
        TRIM(
            RIGHT(field__c,  (LEN(field__c) - 1) ) 
        ),
        (LEN(field__c) - 3)
    )
)

fred

3,5303 gold badges18 silver badges29 bronze badges

answered Sep 28, 2016 at 10:30

highfive

6,2813 gold badges32 silver badges58 bronze badges

Add a comment |

2 Answers 2