On 09/02/12 16:47, Charlie Noah wrote: > I'm exporting from Excel and importing into jBASE. DCOUNTing on the > header line is an excellent idea. I'll give that a try. Since I'm using > a convert routine, if that fixes the problem, it will be fixed for any > spreadsheet I import. > > It may very well be someone hitting Enter when typing, because some > links in the descriptions don't cause this problem. If I could just > detect it in the spreadsheet itself, I could let my distributor know > what's causing it and which rows need fixing on their end. They are > usually pretty good about fixing things, if they know what to do. > I'm sure I've hit this problem ...
ime, these fields are quoted. So if you parse the file properly line-by-line you will run out of data in the middle of a quoted field. You then just have to recover by getting the next line. A pain, I know. It makes parsing a pain in the neck. Then add the problem that the csv format doesn't actually have a proper definition, just because Excel does it one way, doesn't mean other programs will do the same. csv is a de-facto, not a formal, standard, and you need to be careful... Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
