topic Re: extract the number part from a string in QlikView

extract the number part from a string

hosasahana — Wed, 02 Dec 2020 10:51:37 GMT

hi,

I am trying to extract the timing part only from below string, can someone help me on this? I want to extract 30 from this and convert it into seconds.

thanks!

sahana

Re: extract the number part from a string

hosasahana — Wed, 02 Dec 2020 14:42:57 GMT

Can someone help me pl?

Re: extract the number part from a string

Kushal_Chawda — Wed, 02 Dec 2020 14:55:53 GMT

@hosasahana Will the number be always in hours? What kind of values could be?

Re: extract the number part from a string

hosasahana — Wed, 02 Dec 2020 15:12:57 GMT

hi Kush,

thanks for responding. yes the number is always in hours and we have 4 diff values as shown below. I need to extract the 4,8,20 and 30.

Re: extract the number part from a string

Kushal_Chawda — Wed, 02 Dec 2020 15:31:23 GMT

@hosasahana try below

LOAD *, keepchar(TextBetween(Field,'(',')'),'0123456789')*60*60 as Seconds FROM table

Re: extract the number part from a string

hosasahana — Wed, 02 Dec 2020 15:57:33 GMT

thankyou Kush 🙂