Data Extraction
Hello.
I need to extract data from .txt documents into .csv documents organised a certain way. As this is an ongoing project, I would like to be able to do this on a interface that I could use as often as I’d like.
These files will be imported on Excel (2003 (version 11)).
For each project, I have two .txt files which contain subtitles. One is in English and the other is in French. They are named XXXXXX_EN.txt and XXXXXX_FR.txt.
I need to have the timecodes and text extracted to two .csv files which will be named XXXXXX_EN.csv and XXXXXX_FR.csv.
The timecodes used in the English version should always be the ones from the French version, ie the timecodes from the English version should not be copied into the .csv. Rather XXXXXX_EN.csv will contain the timecodes from the French version.
Please have a look at the sample files.
Thanks for your help!
