Shell Programming and Scripting

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 . but i am not sure how to accomplish this.

can anyone please suggest me.

Thanks
Mark

sed 's/\"\"//'

Too fast

Code:

sed 's/""/ /'

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.

Thanks
Mark

sed 's/""/"/'

If it doesn't exactly what you want twiddle yourself with it. Here is how to do it:

The s-command (s is for substitute) is a simple sed-device:

s/<pattern>/<new>/

will change every first occurence of <pattern> in a line with <new>. For example:

s/dog/cat/

will change the first occurrence of the word "dog" on every line to the word "cat".

Code:

Source Text

This is a dog.
One dog chases another dog.

Result Text

This is a cat.
One cat chases another dog.

Notice that only the first occurrence is changed, hence the second "dog" still stands there. If you want every occurrence to be changed use the "g" option for the s-command:

s/dog/cat/g

This would change the second (and any other) occurrence in the second line too.

sed and awk are mighty tools and you should put much effort in learning them when you work in a Unix environment. I recommend Dale Doughertys book "sed & awk" (O'Reilly) as simply the best book i know on this topic.

I hope this helps.

bakunin