Reply to post: Re: User Error

Geneticists throw hands in the air, change gene naming rules to finally stop Microsoft Excel eating their data

Primus Secundus Tertius

Re: User Error

"CSV is a perfectly fine data format for data exchange"

Oh no it isn't! Capital letter 'O' instead of numeral '0', etc. Some years ago, exam results in Scotland were screwed up by that problem in the data.

XML with a schema that enforces data types is something you could write into a contract to ensure reliable data transfers between organisations. You cannot reasonably type XML manually, but Excel can, with difficulty, be made to export that way.

But clearly XML is a non-starter for the situation the article describes.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon


Biting the hand that feeds IT © 1998–2020