3 Replies Latest reply on Mar 19, 2014 3:54 PM by Noah Salvaterra

    Calculated field - dimensions - pulling out specific text

    Sean Bennington

      Hi - I am trying to create a calculated field within a dimension.  The source data within this dimension has a colon with the text.  I would like to strip out everything before the colon and leave the remaining text.

       

      For example:

       

      FEB GM SM 7: Starter and Double

       

      Would like it to say Starter and Double.

       

      The number of characters to left of the colon will always be different which is why i can't use the left or right function to the best of my knowledge.

       

      In addition, i'd like to remove the space after the colon and the beginning of the remaining text.

       

      Would greatly appreciate any help/advice.

       

      -Sean