Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

remove "" Expand / Collapse
Author
Message
Posted Monday, October 6, 2008 12:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 10, 2008 5:34 PM
Points: 54, Visits: 221
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?
Post #581298
Posted Monday, October 6, 2008 12:14 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:35 AM
Points: 1,519, Visits: 4,075
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 :: Running Totals :: Tally Table :: Cross Tabs/Pivots :: String Concatenation
Post #581301
Posted Monday, October 6, 2008 12:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 10, 2008 5:34 PM
Points: 54, Visits: 221
thanks
Post #581306
Posted Tuesday, July 20, 2010 12:59 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:10 PM
Points: 1,414, Visits: 4,541
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

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #955847
Posted Tuesday, July 20, 2010 3:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 16, 2013 8:18 AM
Points: 15, Visits: 45
i guess it can be done from a ssis package with a script task and replace method of string class.

best regards,

tonci.
Post #955945
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse