October 6, 2008 at 12:07 pm
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
Write an Update statement with REPLACE(column,'"','') for each column.
That replace is: REPLACE ( column, ' " ', ' ') in case you can't really read it.
October 6, 2008 at 12:23 pm
thanks
July 20, 2010 at 12:59 pm
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
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