2 Replies Latest reply: Jul 12, 2016 1:36 PM by Neena Bhattarai RSS

    I have a field with values that I would like to split up. However, not all the values are the same. Only some of them I want to split up then drop the first part of the value.

    Neena Bhattarai

      The values are not all the same but some are way to long and I would like to split those values are drop the part I do not want.

      For Example:

      Shipping Code

      ShippingDelivery_3rdDay

      ShippingDelivery_2ndDay

      ShippingDelivery_1stDay

      Standard

      Returns Gound

      Worldwide

      Phone_Request

      Next Day Air Commercial

      Next Day Air Residential

      Next Day Air Early


      Above I would want to take out "ShippingDelivery" and "Next Day Air" and keep all other values alone. Is this possible?