Hello,
I need to extract the numbers that appear in the attached CSV sample. This is what has been extracted from a database.
The numbers 1 to 12 at the end of the string are the months of the year. The numbers beside that are duty hours. So Person Doug Smith did 119:22 duty hours in January.
How can I extract the numbers into different columns?
Row Titles would be:
CREW NAME¦¦Jan¦¦Feb¦¦March¦¦etc
Doug smith
Total hours¦¦Jan
crewname;"time_format(SEC_TO_TIME(sum(TIME_TO_SEC(dutyhours))) '%H:%i')";"month(date)"
Douglas Smith;"119:22";"1"
Douglas Smith;"127:33";"2"
Douglas Smith;"138:31";"3"
Douglas Smith;"117:55";"4"
Douglas Smith;"133:27";"5"
Douglas Smith;"124:10";"6"
Douglas Smith;"152:35";"7"
Douglas Smith;"152:25";"8"
Douglas Smith;"90:53";"9"
Douglas Smith;"130:28";"10"
Douglas Smith;"123:06";"11"
Douglas Smith;"131:34";"12"
Simon Clare;"130:43";"1"
Simon Clare;"129:31";"2"
Simon Clare;"125:04";"3"
Simon Clare;"152:03";"4"
Simon Clare;"127:20";"5"
Simon Clare;"87:11";"6"
Would be great to get some help before tomorrow morning.
Thanks martin
Bookmarks