DSXchange

Hi All,

I have a file with 1 column and its data is as follows;
"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.
awk or sed might be able to do the trick using external filter stage. but i am not sure how to accomplish this.

can anyone please suggest me.

Thanks
Mark

Try this...

sed 's/[""]//g' oldFilename>Newfilename

I missed [] in my previous post...

[quote="filename.txt"]Try...

sed 's/""/,//g'<oldfilename>newfilename[/quote]

it says sed: Function s/""/,//g cannot be parsed.

Thanks
Mark

[quote="filename.txt"]Try...

sed 's/""/,//g'<oldfilename>newfilename[/quote]

it says sed: Function s/""/,//g cannot be parsed.

Thanks
Mark

Try this...

sed 's/[""]//g' oldFilename>Newfilename

I tested it and it should work

I missed [] in my previous post...

Thank you. This is working partially.

Before;

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

After;

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 implement this in data stage. what stage do I have to use to acomplish this.

Thanks a lot.

Thanks
Mark

it is quite simple. read the whole string with quotes (in the file stage set quote=none) and then in a transformer stage trim the " .

Trim(<column name>,'"')

'"' is single quote:double quote:single quote

You must redirect the file output incase you opt to use sed or awk. Rather try to use perl command to find & replace in the same file without redirecting. Incase if the file is large, perl -pi will be much faster than sed.
For example try Other Option
As only one column is with quotes, you can always use datastage functions to remove special charecters , which avoids one unix script stage.

Thanks for all the suggestions.

it is working now.

Thanks
Mark