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.