topic Re: Extract the number value from a string in a field in QlikView

Extract the number value from a string in a field

Wed, 25 Jan 2012 15:19:57 GMT

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

Re: Extract the number value from a string in a field

swuehl — Wed, 25 Jan 2012 15:24:22 GMT

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

Extract the number value from a string in a field

Wed, 25 Jan 2012 15:43:06 GMT

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