A year ago I wrote a CSV related rant on this forum, but then instead of posting it I just closed the window and went on with my life.
Each and every time someone says they'll send me a csv I know I'm going to waste a lot of time. Wikipedia has a small article about the format, you know, comma separated values, sometimes semicolon is used, ... so cute. This little detail is a nightmare, one of those stupidest of all the stupid ideas in computer history.
In US, Excel and similar applications expect comma as a separator. If you have something else, they put everything in a single column. In Europe, Excel and most other applications expect semicolon and if there's anything else then they put everything in the first column.
The thing is, you can not configure this option as you like, it is determined for you in the stupid applications by the country settings. If you get a file from other part of the world, then you're in trouble. Applications will import wrong data, and if you try to find/replace then, .... well, anything is possible.
Just the other day I got the file exported from NeoOffice I think, and the values were separated by the period character, the point, the dot. My God, they should have named the format rsv for Randomly separated values.
And today, I got a file where someone did find/replace on his own and for some reason, on the import side every second row was missing. It took me whole afternoon to realize that by mistake there were extra quotes in one of the columns. As he replaced a part that was before - ,"12.45", he changed it into ;""12,45"; and that double quote pretty much ruined my day. And, like I said, this isn't the first day ruined by csv files. For some reason, I receive them more and more lately. Most of them are not even utf8, so I need to guess the encoding by trial and error and it seems as things are going from bad to worse.
I know there are all kinds of people on this forum, so if anyone here knows the guy who invented csv files, please go near his home and throw a big rock towards the biggest window. I would appreciate that very much. Appologies to everyone else.