Hello,
So i have my whole pipeline working great but there is one data field that im trying to figure out the best way to parse to make it sort able / aggregatable. The data comes in like 20/5:10.080. I had thought about breaking it in to two separate fields but i think i may be over thinking this. the first part is the number of laps and the second part is the total time. Any idea what the best way to parse this would be? The goal is to be able to sort by these lap times, something like a 20/5:01.000 is better than a 20/5:02.000.
Thanks!