Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
You can use the next expression:
=mid(Arrangement,findoneof(Arrangement,' ')+1,len(Arrangement)-findoneof(Arrangement,' '))
Succes!
Try this:
LOAD
Mid([Arrangement], (Index([Arrangement], ' ', 1) + 1)) as [Arrangement]
...
Hi,
You can use the next expression:
=mid(Arrangement,findoneof(Arrangement,' ')+1,len(Arrangement)-findoneof(Arrangement,' '))
Succes!
use one of below
subfield(yourfieldname,' ',2) as yournewfieldname in script or
subfield(yourfieldname,' ',2) in expression
or
subfield(yourfieldname,' ',2) in calculated dimension