I have a table that populates something to the effect of:
Name Start Time End Time Run Time Duration
Test 15:40:39 15:45:39 00:05:00
What I'm trying to create is the following under Run Time Duration = 00H 05Min 00Secs
Any assistance in resolving this would be greatly appreciated.
Hi @cquinney
Try this
| makeresults
| eval "Run Time Duration"="00:05:00"
| rex field="Run Time Duration" "(?P<Hr>\d\d):(?P<Min>\d\d):(?P<Sec>\d\d)"
| eval "Run Time Duration" = Hr."H"." ".Min."Min"." ".Sec."Secs"
Hi @cquinney
Try this
| makeresults
| eval "Run Time Duration"="00:05:00"
| rex field="Run Time Duration" "(?P<Hr>\d\d):(?P<Min>\d\d):(?P<Sec>\d\d)"
| eval "Run Time Duration" = Hr."H"." ".Min."Min"." ".Sec."Secs"
Works perfectly! Thank you!!