Just another Perl shrine | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I have an Excel file that will have data in 5 rows. Some cells have data in multiple lines (using alt-enter).
When going through this data column by column I have a problem where the carriage returns are automatically being processed by Perl so the processing I am attempting on the data is not being done completely. Is there a way of getting rid of these carriage returns? Here is an example of the test data: And here is the output I get when I read in that column of data: cell 1,cell 2,cell 3 cell 4 cell 5,Cell 6,cell 7 So as you can see the carriage returns are being processed by Perl and this is messing up the rest of my functionality. I need to somehow get the script to disregard them. I would like to have all cells of data in the column be outputted to a single line so the rest of my script can process correctly. Any thoughts? In reply to Carriage returns in Excel files by Anonymous Monk
|
|