Extract the number value from a string in a field

[#1]

   I have a field "Machine_number" containing values such as "MB01", "MB02", ..., "MB22", now I would like to have the number only, such as "1", "2", ..., "22". This would allow to use it in a ColorMap as argument. Does any one know how to do this?

Cheers,

Jonas

[swuehl · Accepted solution]

Try

Load

...

Keepchar(Machine_number, '0123456789') as Machine_number,

..

from Table;

edit

or just use above keepchar() in any chart expression to remove the characters.

edit

[#3]

Thanks, I was using it as an expression, and used your proposed line directly in the expression:

ColorMapHue(num(KEEPCHAR(Turbine,'0123456789'))/22)

Perfect, thank you,

Jonas