Yes, parsing csv is a pain. So far it may just be easier to default
format the column, at least until I can get my distributor to fix the
spreadsheet. I save as tab delimited, and as long as I remember to
format first, everything is OK.
Thanks,
Charlie
On 02-11-2012 5:27 AM, Wols Lists wrote:
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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
