--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/script/utils/parse_timecode.py Wed Sep 29 11:03:46 2021 +0200
@@ -0,0 +1,25 @@
+import csv
+import re
+import math
+
+TC_RE = re.compile("(\d{2}) (\d{2}) (\d{2}) ?, ?(\d{2})")
+
+def conver_tc(tc_str):
+ m = TC_RE.match(tc_str)
+ if not m:
+ return math.inf
+ return int(m.group(1))*3600000 + int(m.group(2))*60000 + int(m.group(3)) * 1000 + int(m.group(4)) * 10
+
+if __name__ == "__main__":
+ with open('timecodes_webinaire_fcpe.csv') as csvfilein, \
+ open('timecodes_webinaire_fcpe_out.csv', 'w') as csvfileout:
+ chap_reader = csv.DictReader(csvfilein, delimiter=';')
+ chap_writer = csv.DictWriter(csvfileout, fieldnames=chap_reader.fieldnames, delimiter=';')
+
+ chap_writer.writeheader()
+ for row in chap_reader:
+ if not row['START']:
+ next
+ row['START'] = conver_tc(row['START'])
+ row['END'] = conver_tc(row['END'])
+ chap_writer.writerow(row)
\ No newline at end of file