Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 try below
LOAD *,
keepchar(TextBetween(Field,'(',')'),'0123456789')*60*60 as Seconds
FROM table
Can someone help me pl?
@hosasahana Will the number be always in hours? What kind of values could be?
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.
@hosasahana try below
LOAD *,
keepchar(TextBetween(Field,'(',')'),'0123456789')*60*60 as Seconds
FROM table
thankyou Kush 🙂