AnsweredAssumed Answered

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

Question asked by MoData on May 13, 2015
Latest reply on May 13, 2015 by philmodjunk

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?

 

Outcomes