double quotes

pavan_test · Post by **pavan_test** » Mon Aug 25, 2008 8:50 pm

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

tkbharani · Post by **tkbharani** » Mon Aug 25, 2008 11:56 pm

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

DS_SUPPORT · Post by **DS_SUPPORT** » Tue Aug 26, 2008 12:25 am

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

chulett · Post by **chulett** » Tue Aug 26, 2008 7:43 am

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

chulett · Post by **chulett** » Tue Aug 26, 2008 7:59 am

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.