removing extra double quotes between pipe dilimeter

Shell Programming and Scripting
1

I have a flat file sample like this -

  "COURSE"|"ddddd    "    "    dddd"|"sssddd
  sdsdsdsdx" dddddddd ffffff
  "aaaaa" dddddddd ffffff
  sdsdsd"|"xxxxxxx"|
  "COURSE"|"ffff    "    "    bbbb"|"lllll"|

The delimiter is pipe character (|) and the text are enclosed in double quotes ("). We need to remove the extra double quotes like for example in the text below remove the extra quotes in red , this should be done in the entire file. Between 2 delimiters LINE STARTS with the word �COURSE�, you cannot have more than two quotes, one beginning and one ending�

"ddddd " " dddd"

I need a solution either in awk/sed script.

I am able to separate fields based on | but not able to cut the extra quotes.

2

This seems like homework ...
Please read the rules!

3

Hi
this is not a homework.I am no more a student.
I am able to do this with shell script but am still a beginner in awk/sed

please help

4

Could you show your shell code?

5

I tried the following now :

cat sample | \
  awk -v sep='"' '{
         for(i=1;i<=length($0); i++)
         {
            ch=substr($0,i,1)
            if(ch==sep) {inside=!inside}
            if (inside && ch==" "" ") {continue}
            printf("%s",ch)
         }  }'

doesnt work...

---------- Post updated at 02:31 PM ---------- Previous update was at 01:18 PM ----------

this works :

sed -e 's/\("|"\)/\@/g' -e 's/\("|\)/@/g' -e 's/"//g' -e 's/@/"|"/g' radar.dat

can you tell me what is the awk for this?

6

Are you vishalzone or vishalzone2002 ...