1 Reply Latest reply on Oct 26, 2017 1:22 PM by Branden Kornell

    How to extract data from Dimension that contains a hyphen?

    Teresa Wright

      I need to extract the characters to the right of the hyphen in the column below (Labels3).

       

      screen shot 2.jpg

      I do not have the option on the Data Source tab to split the field.

      screen shot 1.jpg

       

      I found a workbook example using SPLIT, but my version (10.1) is not recognizing the function.

       

      screen shot 3.jpg

       

      Is there a way to quickly extract the characters I need with a calculated field?  Sorry I cannot share data due to security restrictions.