Post reply

How to Remove "double quotes" in SSIS

  • November 15, 2007 at 10:45 am

    #119211

    I have about 103,987 rows that are all full with double quotes. Example is "ABCD". I have 21 columns all together. How do eliminate these double quotes from "ABCD" to just ABCD instead. Urgent help needed.

    [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

  • November 15, 2007 at 12:23 pm

    #751614

    With a derivated column and replace function !!!

    For each column, replace(columname,""","")

  • November 15, 2007 at 8:27 pm

    #751693

    Thank you,

    I used an Update statment and replace to remove "".

    Managed to solve it !

    [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

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

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