CSV file separation

• Gangadhara MS

  Hall of Fame

  Points: 3377

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247140

  More actions

  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).

  ---