EXCEL FOR MAC SOFT RETURN DOWNLOAD
If you are doing this manually, download LibreOffice and use LibreOffice Calc to import your CSV. It's just the line breaks that are causing problems. Note that the comma in "Smith, Joe" is being handled properly. When I import this into Excel 2007, I end up with a header row, and two records. Here's a quick file I wrote by hand to duplicate the problem. Has anyone else encountered this behavior, and if so, how did you fix it? I've also tried replacing CR/LF (\r\n) with just CR (\r), and again with just LF (\n), but no luck.
However, when I import the data into Excel 2007, set the appropriate delimiter, and set the text qualifier to double quote, the line breaks are still creating new records at the line breaks, where I would expect to see the entire text field in a single cell.
In order to counteract this, I have wrapped the field in double quotes ("). One of the fields is a free-text field, which may contain line breaks, commas, quotations, etc. I'm working on a feature to export search results to a CSV file to be opened in Excel.
0 kommentar(er)
