extract the number part from a string

[hosasahana]

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

[hosasahana]

Can someone help me pl?

[Kushal_Chawda]

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

[hosasahana]

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.

[Kushal_Chawda · Accepted solution]

@hosasahana  try below

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

[hosasahana]

thankyou Kush 🙂