I was going to comment on the reason for your problem but I've been beaten to it. However I will make one comment that I make for most questions involving CSV files:
Do not parse CSV files yourself! Use existing libraries such as Text::CSV, Text::CSV_XS, Tie::CSV_File,Tie::Handle::CSV, anything except do it yourself methods.They will automatically handle quoted fields and other CSV gotchas without you noticing most of the time. Reading CSV files line by line and using split is a poor way of doing things, only to be used in the most basic of circumstances. If someone has done all the difficult stuff for you, take advantage of their hard work.
If you spot any bugs in my solutions, it's because I've deliberately left them in as an exercise for the reader! :-)
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||