topic extract numericals? in QlikView

extract numericals?

qlikuser222 — Wed, 20 Apr 2016 21:44:31 GMT

Hi All,

I have filed values like

Start - 6 Days

Not Start - 7 Days

can any on please How can I extract numerical from the above field values??

Thanks

sunny_talwar — Wed, 20 Apr 2016 21:58:28 GMT

Try this:

KeepChar(FieldName, '0123456789') as NewFieldName

swuehl — Wed, 20 Apr 2016 22:30:05 GMT

Just to offer another option (and there are lot more, have a look at the QV string functions in the HELP), depending on your exact requirements:

LOAD *,

KeepChar(Text,'0123456789') as Number1,

TextBetween(Text, '-','Day') as Number2;

LOAD * INLINE [

Text

Start - 6 Days

Not Start - 7 Days

Started to early - -1 Day

2 times started - 2 Days

Worked part time - 0.5 Days

];