Help with data processing, maybe awk

Shell Programming and Scripting
1

I have a file, first 5 columns are very normal, like

"1107",106027,71400,"Y","BIOLOGY",

,
however, the 6th columns, the user can put comments, anything, just any characters, like new line, double quote, single quote, whatever from the keyboard, like

"Please load my previous SOM597G course content in the fall of 2009 into this course. I have two sections in this course.
Thank you.
Andy Pam"

, the 7th column is very normal, either "", or "Check with admin".

The thing is how I can extract the comment column out for each record, since it can be any kind of characters.

Thanks a lot!

"1107",106027,71400,"Y","BIOLOGY","please check with me.
Thanks.
Linda", ""
"1107",106027,71401,"Y","BIOLOGY","thanks", "Check with admin"
"1107",106027,71402,"Y","BIOLOGY", "Please refer to course "fa09 biology",
thanks.",""
"1107",106027,71403,"Y","BIOLOGY", "",""
"1107",106027,71404,"Y","BIOLOGY","Hey,
I am new for this semester.
Thanks.
Doris.",""

want the output to be like this:

comment1: please check with me.
Thanks.
Linda
comment2: thanks
comment3: Please refer to course "fa09 biology",
thanks.
comment4:
comment5: Hey,
I am new for this semester.
Thanks.
Doris.
2

Hi

#sed 's/\"//g' a | awk '/^[0-9]+/{print "comment"i++":",$6;next}{print $1}' FS=,  i=1
comment1: please check with me.
Thanks.
Linda
comment2: thanks
comment3:  Please refer to course fa09 biology
thanks.
comment4:
comment5: Hey
I am new for this semester.
Thanks.
Doris.
#

Guru.

3

thanks a lot! It is working on this temp file, and I will test on the official file again on Monday. Thank you so much!

Actually, the double quote, comma are allowed in the comments. Need to think about a more secure way for the field separators.

4 
sed 's/,/|/5' file|sed 's/.*|//;s/,[ \t]*"Check with admin"//;s/,[ \t]*"".*//'