3 Replies Latest reply: Apr 29, 2015 10:23 AM by Travis Russo RSS

    Trim last part of text field with variable lengths

    Travis Russo

      Hello,

       

      I am trying to cut the last part of the field that is the last instance of an underscore ("_"). For instance, I have a field with the 2 values below:

      1. CREDIT_ONLY_LAX
      2. RET_LINE_WITH_CREDIT_LS_GB

       

      I want to cut the "_LAX" from the first example and the "_GB" from the second example. The result would then be:

      1. CREDIT_ONLY
      2. RET_LINE_WITH_CREDIT_LS

       

      Any help would be great. My difficulty here is that it cannot be hard coded such as left(field, len -3) as it could range from 2-5 characters that I'm trying to cut off.

       

      Thanks!