Bashscripts.org

This may be a fairly easy thing to do, but unfortunately I have been searching around and cannot find an answer. Very frustrating.
I have a file (csv) that needs to be split into various fields in bash. An example of the first line is here:

2 ,"Rainbow Warrior : Battle for the Planet","An extra-ordinary adventure","MORRIS, Jill","Greenpeace Foundation. Rainbow Warrior (Ship). Environmental Protection. Nature Conservation.","363.7 MOR","1862913439","Norwood, SA : Omnibus,1998",

Part of my problem is that in the 5th field ("Greenpeace Foundation. Rainbow Warrior (Ship). Environmental Protection. Nature Conservation.") it's split with these large gaps of blank space. Can anyone please help me sort this out???

Thanks in advance,
Kate

also another problem here is not splitting the fields when the , is inside a " ". For example "SMITH, Mary", "......

If everything is in double quotes, split on double quotes. If double quotes might be escaped or newlines can appear inside double quotes, I'd use perl and Text::CSV.

Personally, I'd output the csv file with a "|" delimeter and NOT a "," delimiter.
Import the file into a spreadsheet, export it with a "sane" delimiter.

You "could" split on double quotes...until you only have one double quote or no double quote...and I've dealt with data that can't be guaranteed to be sane before. The only logical method for me was to export the data with a delimiter that wasn't in the data as well.