String manipulation on both start and end

[SmoothOperator]

Hello,

I have a variable called varBase which has a looooong string value inside. 

I want to "trim it" and especially delete some characters on both start and end of this value. 

I have managed to remove the first 22 characters that I want out, by using :
Right(varBase, Len(varBase) -22)

However, simultaneously i want to remove the double quote character "  [Ascii 34 / Char(34)] at the end.
Any ideas anyone?

[rubin_boer · Accepted solution]

hi @SmoothOperator  Mid(Right(varBase, Len(varBase) -22),1,len(Right(varBase, Len(varBase) -22))-1)

[Drrickryp]

@SmoothOperator 

Substitute(Right(varBase, Len(varBase) -22),""","")

if there was only one " in the string.  If there are more and you want to replace the last one

With(
    {no:CountRows(MatchAll(varBase, """)),
Substitute(Right(varBase, Len(varBase) -22),""","",no)

[SmoothOperator]

really appreciate your quick responses!!! @Drrickryp @rubin_boer