November 10, 2004 at 10:41 am
Hi,
Just wanting to hear peoples experiences in dealing with commas in fields (mainly address fields) which, if left alone, may shift columns when exporting in csv format.
Do you leave them in the dB and deal with the problem when exporting or maybe replace each occurence in the dB with a space, or delete them. Same goes for apostrophes (') screwing up dynamic queries.
Any comments?
November 14, 2004 at 8:22 pm
What are you using to do the export? If you are using BCP and use \" to enclose text fields in quotes in the format file, you should have no problem with anything except embedded double quotes. Commas and apostrophes will not be a problem. If you use tab delimeted fields instead of CSV, you won't have a problem with any characters other than embedded tabs and most folks just don't embed tabs in fields.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply