Getting Data In

convert hours minutes to epoch time

architkhanna
Path Finder

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

0 Karma

vnravikumar
Champion

Hi

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
0 Karma

493669
Super Champion

You can use regex like below-

|rex mode=sed field=yourcolumnname "s/(\d+)h\s*(\d+).*/\1.\2/g"
0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.