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

derived column --replace " with space expression error Expand / Collapse
Author
Message
Posted Thursday, May 20, 2010 9:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 17, 2011 8:06 AM
Points: 31, Visits: 123
Hi

in my package i am getting data from txt file and loading in to table sqlserver 2005.
there is one column as mentioned below in txt file

Lname
-------
ASD
ABCED
ASFGTE
K"C"ASDF ------------ replace " with space
PLKJH

now i want to replace the " with sapce
so i have used drived column transformation and using the following expression

Replace([Lname],"\"","")

but its not working

can any one help me with this ??






Post #925210
Posted Thursday, May 20, 2010 10:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 17, 2013 4:51 PM
Points: 215, Visits: 556
The syntax looks correct.. can you post the error?
Post #925338
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse