DSXchange

Hi All,

I have a file with 1 column and its data is as follows;

Before:
"Happy Hour, Party on 18"" staged on 20th."

My Expected result;

Happy Hour, Party on 18" staged on 20th.

Can anyone please suggest me how do I remove the embedded quote in data stage while reading this column.

Thanks
Mark

Please do not post the same question in different forums. Please delete it.

Trim Function will help you. Read all the combination of Trim in the Help.

Have you tried just reading it as is? What result do you get? That 'embedded quote' should resolve itself normally, I would think.

viewtopic.php?p=297730

Do not post the same question in multiple forums marked as different job types. You either have a Server specific question or a PX specific one, not both. You just waste our time responding to questions with either an inappropriate answer or to a 'problem' that has already been resolved, like this one.

On those rare occassions when it truly is for both, post in the General forum and make it obvious you are looking for a 'job type agnostic' answer.