none
Remove quotes in Bulk Insert RRS feed

  • Question

  • Hi all

     

    I am importing a csv, there are quotes around all the field data which i would like to remove on import.

    Is this possible??

     

    Thanks

     

    Rich

    Monday, November 12, 2007 2:54 PM

All replies

  • Could you import the data then cleanse it once it has been imported?

     

    Something like:

     

    UPDATE MyTable

    SET MyFirstColumn = REPLACE(MyFirstColumn, '"', ''),

    MySecondColumn = REPLACE(MySecondColumn , '"', '')

    etc...

     

    ?

     

    Chris

    Monday, November 12, 2007 7:10 PM
  • Thanks Chris, I thought that would be the answer was hoping I could be it on import.

     

    Tuesday, November 13, 2007 9:08 AM