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.
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy