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

    Removing prefix from expression



      I have a dimension with the following expression:




      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!