Reply to post: Re: I must be missing something...

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

John Brown (no body) Silver badge

Re: I must be missing something...

"Excel's import of text files has always been miserable, though this isn't helped by the deficiencies of the CSV format. But it really would be useful to be able to disable type inference as a preference and not fiddle with it, file by file."

Thankfully, I've not had to deal with the vagaries of CSV files and various programs' methods of imparting them for many, many years. But I do remember having to wrangle CSV files to get them into DBase II, Delta, SuperCalc and Lotus123, often writing code specific to a particular CSV file to make it look like what the destination program expected.

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