Post reply

CSV Export of Blob Data

  • June 22, 2009 at 11:27 am

    #135382

    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

    #1013478

    Nothing tidy. Use another character as your field delimiter, or replace/delete the commas before you export the BLOB.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • June 22, 2009 at 11:44 am

    #1013490

    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

    #1013653

    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.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 23, 2009 at 12:57 pm

    #1014185

    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