如何在Perl中处理CSV文件中的嵌入换行？

I'm reading a .csv file that was created in Excel with the first line being column headings. One column heading contains an embedded newline. I want to ignore that newline but reading it line-by-line like:I'm reading a .csv file that was created in Exc