Post reply

remove ""

  • October 6, 2008 at 12:07 pm

    #193973

    i have a table having double quotes (" ") in all 10 columns.

    (sample values like "10101" ,"1291919"," id of year", " rent information" etc....)

    How to remove "" fom all columns?

  • October 6, 2008 at 12:14 pm

    #881272

    Write an Update statement with REPLACE(column,'"','') for each column.

    That replace is: REPLACE ( column, ' " ', ' ') in case you can't really read it.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • October 6, 2008 at 12:23 pm

    #881276

    thanks

  • July 20, 2010 at 12:59 pm

    #1195751

    is there a way to do it within SSIS using the transformations? i want to change some data types to other that string types and it would mean i would have to get rid of the " before they hit the database

  • July 20, 2010 at 3:22 pm

    #1195825

    i guess it can be done from a ssis package with a script task and replace method of string class.

    best regards,

    tonci.

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

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