3 Replies Latest reply: Oct 17, 2011 4:53 AM by Sunil Chauhan RSS

    Removing prefix from expression

      Hello,

       

      I have a dimension with the following expression:

       

      Arrangement

       

      now how this comes out in the chart is such as this:

       

      023 Hotel services

      4122 Flight services

      482a Transport services

       

      My question is, how should I edit the expression to remove the numbers, letters and the empty space in front of the arrangement names? All names have a three to four character prefix with numbers, but the fourth character can be a letter. To get a result like this:

       

      Hotel services

      Flight services

      Transport services

       

      Many Thanks!