Date format

ForumCategory: QuestionsDate format
Mate Foldi asked 4 months ago

Hey all,
I have uploaded a Factiva file to Cortext, which I then downloaded in CSV format and cleaned up on Open Refine. However, my date column has been put into the following format: “1 September 2018”. How can I change this to the required Cortext format?

Thank you!

1 Answers
Jean-Philippe Cointet Staff answered 4 months ago

Dear Mate, 
CM only manages to parse dates formatted this way: Y-m-d, 2018-10-15 for instance.
It is probably possible to use some excel/open office functions to modify the formatiing of your data.
Please note, that factiva exports can be readily imported in CorText using html files as explained here: 
Good luck

Mate Foldi replied 4 months ago

Thank you very much!

Mate Foldi replied 4 months ago

so I have cleaned my dataset and most dates are now in the YYYY-MM-DD, but some are YYYY-MM-D — so 2018-01-01 vs 2018-01-1 . Does this pose problems for Cortext?

Jean-Philippe Cointet Staff replied 4 months ago

The datetime library from python is used to parse dates (using function strptime). I think it should be robust to this but worth to be checked manually after the data was parsed (original date string will be kept!)

learn about CorText scripts and share your experience