test content
  • Games
  • Social
  • Arc News
  • Support
  • Zen
What is the Arc Client?
Install Arc
Forums > Home› Feedback› Fleet System and Holdings

.csv file question

sevexparsevexpar Member Posts: 66 Arc User
in Fleet System and Holdings
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

Comments

  • frtoasterfrtoaster Member Posts: 3,352 Arc User
    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.
    Waiting for a programmer ...
    qVpg1km.png
  • belidosbelidos Member Posts: 452 Arc User
    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.
Sign In or Register to comment.