1 Reply Latest reply on May 13, 2015 2:34 PM by philmodjunk

    How to remove X characters from beginning or end of a string

    MoData

      Title

      How to remove X characters from beginning or end of a string

      Post

      Let's say I have multiple records in which there is a particular field containing data that looks like:

      ABC-DE-1000

      ABC-DEF-1001

      How can I remove the 5 rightmost characters so I'm left with:

      ABC-DE

      ABC-DEF

      I don't think I can use Left since there are different numbers of characters leading up to the unwanted 5 characters. The characters I don't want are: Right( field_name, 5 ). How do I erase them?