Sample problem : Function Replace() in Derived Column

Hello All.

Hopefully someone out there will have an idea as this isdriving me nuts.
Ihave some sample problem. I want to use function replace() on Derived Column.
For example.
when strDate = 2007/03/22

I used ==> replace(strDate, "/", "") ==> 20060322

But If strTest = "123.10" ====>> 123.10

How can i do to replace ( " )double qoute ?
by function replace()

what is a statement for replace (") in Derived Column ?

please tell me for this event.

any suggesstion appreciated
Thank you very much.

Chonnathan

Not sure without testing, but try escaping it.

replace(strTest,"\"","")|||Note: Please try not to delete your posts. I had a reply submitted to your deleted post.

Never-the-less, this does work:

In my test, column test01 was populated with the text string,

TES"T. After running through my derived column with the below

expression, the result was TEST (without the double quote).

REPLACE(test01,"\"","")

What version of SSIS are you using? (SP1? SP2? initial release?)