Remove the qotes

[Poonam Singh]

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

[ArndW]

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)

[kris007]

Code: Select all

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

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