Skip to main content
Question

Deleting end characters

  • November 10, 2018
  • 0 replies
  • 83 views
I'm having difficulty trying to strip out the middle of a text string. Below is an example of the record as it is entered into Quickbase in the field [Name]:

[NYC OM] On Model - Standard - /10222018_NYS1_UNREC_M_1869_OUTPUT/ColorCorrect/

What I want to display in a new field is:

10222018_NYS1_UNREC_M_1869_OUTPUT/ColorCorrect

So far what I have working is:

NotLeft(Trim([Name]),"/")

This works to trim off the beginning so that I have
10222018_NYS1_UNREC_M_1869_OUTPUT/ColorCorrect/

However I really want to get rid of that trailing backslash at the end. The problem is that I also need to make sure I keep the backslash separating the word OUTPUT and ColorCorrect.

I can't find a formula that works. There must be a way to just look at the very end of the whole string and remove one character, I just can't figure it out.
    This topic has been closed for replies.

    Try this

    var text StepOne = NotLeft(Trim([Name]),"/");

    IF(Ends($StepOne, "/"), NotRight($StepOne,1), $StepOne)
    Terms & ConditionsAccessibility statement