in reply to Reading in data that is
Your problem is that split with no arguments will split on whitespace - and your data record contains lots of white space within the fields.
You probably want a split regualar expression something like this:
But that will still leave you with extra quotes in the first and last fields that you'd have to remove.--
"The first rule of Perl club is you don't talk about Perl club."