I'm thinking the opposite on this one. It's exporting that's the problem.
If you try to save a word table as a csv file, it won't quote any fields
that have a comma, so your importing program gets all screwed up.
We had a few people that kept their databases as a Word File in a Table,
and would export the table. This was on Word 97, so possibly this has
been addressed since then.
Don't ask why they were using Word for a database. I'd rather not go
there again :)
Tabs sometimes will be expanded by the importing program (not excel) which
might be a reason why commas would need to be used, and of course there is
also the reason because whoever wrote the importing program that this
csv file needs to go to didn't think about having tabs a possible delimiter.
George
>-----Original Message-----
>From: Tony Gravagno [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, February 03, 2004 4:48 PM
>To: 'U2 Users Discussion List'
>Subject: RE: using commas in a csv file output
>
>
>Once again you're looking at the problem like a nail because
>you're swinging
>at it with a CSV hammer. First import Tab-delimited text into your
>document. Then go to menu> Table >Convert >Text to Table.
>All of this can
>be automated.
>
>George, what kind of import are you suggesting for a Word table?
>
>Tony
>
>From: George Gallen
>that doesn't work if you are reading the data into a Word
>Table. It doesn't
>recognize
>quotes as ignore comma switch.
>
>Excel, however, respects it without a problem.
>
>From: Kevin King
>quote the entire data value.
>
>From: Simon Adams
>How can I force a comma in an outputted csv file ?
>
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
