Discussions

Expand all | Collapse all

Deleting end characters

  • 1.  Deleting end characters

    Posted 11-09-2018 22:55
    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.


  • 2.  RE: Deleting end characters

    Posted 11-09-2018 23:01
    Try this

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

    IF(Ends($StepOne, "/"), NotRight($StepOne,1), $StepOne)


  • 3.  RE: Deleting end characters

    Posted 11-12-2018 15:40
    Perfect! Thank you