DSXchange

Posted: **Mon Dec 19, 2011 9:12 pm**

I have a strign like this assigned to a column:

"IBM G52 17"" COLOR MONITOR (476)"

I want to convert this to

IBM G52 17 COLOR MONITOR (476)

Tried using the following in Trim. But it gives a syntax error:

Trim(Trim(ToTfm.DESCRIPTION, "\""), " ")

Any inputs pls? Thank you.

Posted: **Mon Dec 19, 2011 9:28 pm**

For me it looks like:

Convert(",'',trim(input))

If the above doesnt work try:

Escape the first argument \" and try.

Posted: **Mon Dec 19, 2011 9:38 pm**

You just need to remove the double quotes? No need to escape anything, just use single quotes in the function call:

Convert('"','',ToTfm.DESCRIPTION)

Posted: **Mon Dec 19, 2011 10:21 pm**

Craig - that worked good. Why didnt I think of this. I was always trying to use the escape character.

How to handle this string