Tuesday, March 27, 2012

Derived Column Task Replace Quotes

How do you replace quotes in an expression

I mean for example if I needed to replace xx in a string with empty string then the following works: REPLACE(SelectedString, "xx","")

But the example I have needs to actually replace quote marks in a string with an empty string and REPLACE(SelectedString, " " ","") doesn't work. I tried guessing a few option like &QUOTE or &QTE or something...

Any ideas ?

Thanks

Richard

Got it !! :

REPLACE([Selected Closing],"\"","")

No comments:

Post a Comment