P is for Practical | |
PerlMonks |
Re^2: split large CSV file >9.1MB into files of equal size that can be opened in excelby stevieb (Canon) |
on Sep 28, 2016 at 21:02 UTC ( [id://1172866]=note: print w/replies, xml ) | Need Help?? |
Have you taken a look at the split csv files? You're splitting in bytes, which means that unless your csv files are *very* reliably structured, you will likely break the file up into chunks that break full lines. Say you have a file like this:
and a read statement like this:
You'll end up with split file one with:
and the second split file with:
Which might not be what you wanted.
In Section
Seekers of Perl Wisdom
|
|