topic convert hours minutes to epoch time in Getting Data In

convert hours minutes to epoch time

architkhanna — Thu, 11 Jul 2019 07:03:49 GMT

I have a collumn which has values like 2h 50 m ,3h 10 m etc.
Is there a way to convert this to a value like 2.50,3.10 etc

Any leads would help.
TIA

Re: convert hours minutes to epoch time

493669 — Thu, 11 Jul 2019 07:24:43 GMT

You can use regex like below-

|rex mode=sed field=yourcolumnname "s/(\d+)h\s*(\d+).*/\1.\2/g"

Re: convert hours minutes to epoch time

vnravikumar — Thu, 11 Jul 2019 17:24:59 GMT

Try this

| makeresults 
| eval test="2h 50 m ,3h 10 m" 
| makemv delim="," test 
| mvexpand test 
| eval test=replace(replace(test,"h\s","."),"\s{0,}m\s{0,}","") 
| mvcombine delim="," test 
| nomv test