extract numericals?

[qlikuser222]

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]

Try this:

KeepChar(FieldName, '0123456789') as NewFieldName

[swuehl · Accepted solution]

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

];

Text	Number1	Number2
Start - 6 Days	6	6
Not Start - 7 Days	7	7
Started to early - -1 Day	1	-1
2 times started - 2 Days	22	2
Worked part time - 0.5 Days	05	0.5