Hi<br>I know this sounds simple, but this is the first time i have run into it and am spending more time than i would like trying to figure it out.<br><br>I have a .csv file (all great stories start with either "I had this .csv file".. or .. "dude, hold my beer") and it follows the usual csv norm.. i am working on a winxp box and my output will eventually be another .csv file read by excel on another xp box.<br>
<br>data,"data","data with a comma,data",normal data,"and data"<br><br>It just so happens that some of the data has a CRLF smack in the middle<br><br>I am using Text::CSV for the first time and am liking the power to deal with the commas and quotes and stuff.. but i am having problems with the CRLF in the middle of the data.<br>
<br>The perldoc page says if you run into non ASCII characters use binary mode.. but the CRLF isn't non ASCII.<br><br>Whats the most normal/easiest way to deal with CRLF in the data without screwing up the normal end of line? I need to sanitize the data somehow and am drawing a blank.<br>
<br>I have been searching online for something but am coming up without any good meat.<br><br>Thanks a billion.<br>Mike<br><br>-- <br>/dev/mike0<br><br><a href="http://www.mikeferrari.com">http://www.mikeferrari.com</a>