Removing prefix from expression

[#1]

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!

[Anonymous]

Try this:

LOAD

  Mid([Arrangement], (Index([Arrangement], ' ', 1) + 1)) as [Arrangement]

  ...

[#3 · Accepted solution]

Hi,

You can use the next expression:

=mid(Arrangement,findoneof(Arrangement,' ')+1,len(Arrangement)-findoneof(Arrangement,' '))

Succes!

[SunilChauhan]

use one of below

subfield(yourfieldname,' ',2)  as yournewfieldname in  script or

subfield(yourfieldname,' ',2) in expression

or

subfield(yourfieldname,' ',2) in calculated dimension