DBD::CSV has always worked best for me with CSVs and lets me suck it all into an HoH, but not sure it would work with a file like the one you're describing, albeit what you're describing doesn't sound like a CSV in the conventional sense...