Post reply

CSV file separation

  • February 15, 2011 at 3:03 am

    #231388

    Dear All,

    I am extracting the Address fields from the varchar field and its separated by comma in the address field to a .csv file format using SSIS.

    When loading from the SSIS .csv file one field is shifting because of one comma in the address field.

    How do we avoid this.

    Thanks,

    Gangadhar

  • February 15, 2011 at 3:08 am

    #1286936

    Unless the offending text fields have their own delimiter, eg:

    "kdfjgasdg, dasfsjfg ", 5,10,"dkjhkh, asdkjhaksdj"

    There is not much you can do, other than asking whoever provides the information to help (by adding a text delimiter, changing the field delimiter to something else, or stripping out the commas at source).

Viewing 2 posts - 1 through 2 (of 2 total)

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