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,