diff -r 61423ca4e0af -r 82b5f22448f6 script/utils/parse_timecode.py --- /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