DSXchange

Posted: **Tue Oct 10, 2006 10:49 am**

Hi,

I have one character column name xyz in which I have some characters with quotes. I need to get rid or the quotes.
Please help me out.
example
xyz
UBIT "O"

3144 N "G"

XUDM "XU"

I want the result like that
UBIT O

3144 N G

XUDM XU

Posted: **Tue Oct 10, 2006 11:09 am**

Welcome to DSXChange. You will find you get quicker answers when you post in the correct forum. You can use the TRIM function to do this, with TRIM(In.ColumnName,'"','A') or CONVERT('"','',In.ColumnName)

Posted: **Tue Oct 10, 2006 11:10 am**

Code: Select all

Trim(InputLink.ColumnName, '"', 'A')

Notice that you need to enclose the quote character in single quotes.

DSXchange

Remove the qotes

Remove the qotes