.csv file question

sevexpar

Hi all.

I need an Excel or Open Office maven.

The log has the data in a basically worthless format.

Has anyone managed to get the data sorted using any of the date fields? If you have, please share.

Thank you!

Sev

frtoaster

The problem is that the column is interpreted as text by default. It might be easier for people if Cryptic output the date and times in ISO 8601 format as emzi0767 suggested:

http://perfectworld.vanillaforums.com/discussion/1194811/csv-exports

In LibreOffice, you can check "Detect special numbers" when you open the CSV file. Another option would be use another column to convert the text to numbers and sort by the new column; for example,

=datevalue(I2) + timevalue(I2)

The numbers can be reformatted as dates and times.

belidos

It would be even easier if they just outputted in XML like most other games with similar features do, it's so much easier to process.