5 Replies Latest reply on Mar 31, 2013 2:21 PM by Shawn Wallwork

    Trimming a dimension value

    Daniel Vincent

      I have a dimension called 'Code' with the following setup:  site_product_#_fullname. So the values in any said cell could be ABCD_43-B06-F-ad_3_Widget.  Keep in mind the value lengths are never consistent.  I need to figure out how to limit between the first under score and the next.

       

      From the above example I want to just show the product (43-B06-F-ad) and wasn't sure how to accomplish this.

       

      Any ideas/help would be appreciated.