A few people missed this (myself included).
You have to split on a pair of double quotes or no quotes at all. There's the field with commas in it which you can't replace with a pipe so a simple regex or split/join won't work (at least without a massive regex on the split).
in reply to Re: swapping PIPE for comma in CSV file
in thread swapping PIPE for comma in CSV file