June 22, 2009 at 11:27 am
Hey,
I need to export blob or text data to a csv file. The problem i am coming across is that this data sometimes contains a comma in it. These comma's are causing the columns to get thrown off. Is there any way to get around this?
Thanks everyone for you help,
Paul
June 22, 2009 at 11:32 am
Nothing tidy. Use another character as your field delimiter, or replace/delete the commas before you export the BLOB.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 22, 2009 at 11:44 am
Thanks for your help, i was trying to avoid those solutions. I guess we will have to change the delimiter.
Thanks again
June 22, 2009 at 6:25 pm
paul.corujo (6/22/2009)
Hey,I need to export blob or text data to a csv file. The problem i am coming across is that this data sometimes contains a comma in it. These comma's are causing the columns to get thrown off. Is there any way to get around this?
Thanks everyone for you help,
Paul
Have you tried putting quotes (") around the field values? I think this should help with the commas in the fields.
June 23, 2009 at 12:57 pm
Thanks so much for your help. We ended up altering the app and using bcp at the command line. We did ||| just to make sure it wouldn't be part of the text.
Thanks again...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply