Post reply

Handling spurious commas in csv

  • April 1, 2016 at 2:45 am

    #317461

    Hi,

    I've started to encounter a CSV source that contains extra commas in columns.

    Example lines of data show that it appears in address lines and for these cases the column is surrounded by double quotes.

    ID,Address,City,Country

    1001, "My House Name, 10 new street",London,UK

    1001, 20 main street,New York,USA

    Requesting the data as pipe delimited would be one option but I just thought I'd share this and see if another work around is out there so that the expected csv format can be retained.

    Thanks,

    Eamon

  • April 1, 2016 at 2:54 am

    #1869076

    Eamon

    Is there not an option in the Flat File Connection Manager in SSIS to overlook any delimiters that are enclosed in quotes? If not, I can't think of any option but to use a different delimiter.

    John

  • April 1, 2016 at 3:09 am

    #1869078

    thanks alot, added " as a delimiter and it sorts it.

    Regards,

    Eamon

  • April 1, 2016 at 3:10 am

    #1869079

    Yes, in the Flat File Connection Manager set a value of " for the Text Qualifier.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply