What steps will reproduce the problem?
1. Make a query that contains newlines, both \r\n and \n
2. Click the wheel icon in the results pane and select "Export results" -> "As
CSV file"
3. Press OK
What is the expected output?
A CSV file readable by OpenOffice or Numbers.app (by drag'n'dropping it, direct
open will never work) or CloudConvert
What do you see instead?
1st column data is garbled with data from the previous row due to the previous
row having columns that contains newlines like a TEXT field.
The newlines are simply not escaped, which makes the entire CSV file unreadable
any of my tools.
What version of Sequel Pro are you using?
version 1.0.2 build 4096
What version of OS X are you using?
10.8.5
What version of MySQL are you connecting to on the server?
5.5
Attached screenshot is a snippet, not an entire file.
Original issue reported on code.google.com by scarlac@gmail.com on 4 Oct 2013 at 8:52
Original issue reported on code.google.com by
scarlac@gmail.com
on 4 Oct 2013 at 8:52Attachments: