{"action":"created","issue":{"url":"https://api.github.com/repos/sequelpro/sequelpro/issues/1821","labels_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/1821/labels{/name}","comments_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/1821/comments","events_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/1821/events","html_url":"https://github.com/sequelpro/sequelpro/issues/1821","id":22380627,"number":1821,"title":"CSV exports does not escape newlines","user":{"login":"sequelpro","id":863151,"avatar_url":"https://avatars.githubusercontent.com/u/863151?v=3","gravatar_id":"","url":"https://api.github.com/users/sequelpro","html_url":"https://github.com/sequelpro","followers_url":"https://api.github.com/users/sequelpro/followers","following_url":"https://api.github.com/users/sequelpro/following{/other_user}","gists_url":"https://api.github.com/users/sequelpro/gists{/gist_id}","starred_url":"https://api.github.com/users/sequelpro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sequelpro/subscriptions","organizations_url":"https://api.github.com/users/sequelpro/orgs","repos_url":"https://api.github.com/users/sequelpro/repos","events_url":"https://api.github.com/users/sequelpro/events{/privacy}","received_events_url":"https://api.github.com/users/sequelpro/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sequelpro/sequelpro/labels/Bug","name":"Bug","color":"fc2929"},{"url":"https://api.github.com/repos/sequelpro/sequelpro/labels/Priority-Medium","name":"Priority-Medium","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"stuconnolly","id":223144,"avatar_url":"https://avatars.githubusercontent.com/u/223144?v=3","gravatar_id":"","url":"https://api.github.com/users/stuconnolly","html_url":"https://github.com/stuconnolly","followers_url":"https://api.github.com/users/stuconnolly/followers","following_url":"https://api.github.com/users/stuconnolly/following{/other_user}","gists_url":"https://api.github.com/users/stuconnolly/gists{/gist_id}","starred_url":"https://api.github.com/users/stuconnolly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stuconnolly/subscriptions","organizations_url":"https://api.github.com/users/stuconnolly/orgs","repos_url":"https://api.github.com/users/stuconnolly/repos","events_url":"https://api.github.com/users/stuconnolly/events{/privacy}","received_events_url":"https://api.github.com/users/stuconnolly/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2013-11-09T05:51:04Z","updated_at":"2015-12-02T12:25:16Z","closed_at":null,"body":"Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=1821\r\nReporter:scarlac@gmail.com Date:2013-10-04 01:52:51 Status:New\r\n\r\n<b>What steps will reproduce the problem?</b>\r\n1. Make a query that contains newlines, both \\r\\n and \\n\r\n2. Click the wheel icon in the results pane and select &quot;Export results&quot; -&gt; &quot;As CSV file&quot;\r\n3. Press OK\r\n\r\n<b>What is the expected output?</b>\r\nA CSV file readable by OpenOffice or Numbers.app (by drag'n'dropping it, direct open will never work) or CloudConvert\r\n\r\n<b>What do you see instead?</b>\r\n1st column data is garbled with data from the previous row due to the previous row having columns that contains newlines like a TEXT field.\r\nThe newlines are simply not escaped, which makes the entire CSV file unreadable any of my tools.\r\n\r\n<b>What version of Sequel Pro are you using?</b>\r\nversion 1.0.2 build 4096\r\n\r\n<b>What version of OS X are you using?</b>\r\n10.8.5\r\n\r\n<b>What version of MySQL are you connecting to on the server?</b>\r\n5.5\r\n\r\nAttached screenshot is a snippet, not an entire file.\r\n![screen shot 2013-10-04 at 10 51 11](https://cloud.githubusercontent.com/assets/5793864/10987050/c2da435c-842f-11e5-8738-947951281592.png)\r\n"},"comment":{"url":"https://api.github.com/repos/sequelpro/sequelpro/issues/comments/161277048","html_url":"https://github.com/sequelpro/sequelpro/issues/1821#issuecomment-161277048","issue_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/1821","id":161277048,"user":{"login":"kwando","id":891566,"avatar_url":"https://avatars.githubusercontent.com/u/891566?v=3","gravatar_id":"","url":"https://api.github.com/users/kwando","html_url":"https://github.com/kwando","followers_url":"https://api.github.com/users/kwando/followers","following_url":"https://api.github.com/users/kwando/following{/other_user}","gists_url":"https://api.github.com/users/kwando/gists{/gist_id}","starred_url":"https://api.github.com/users/kwando/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kwando/subscriptions","organizations_url":"https://api.github.com/users/kwando/orgs","repos_url":"https://api.github.com/users/kwando/repos","events_url":"https://api.github.com/users/kwando/events{/privacy}","received_events_url":"https://api.github.com/users/kwando/received_events","type":"User","site_admin":false},"created_at":"2015-12-02T12:25:16Z","updated_at":"2015-12-02T12:25:16Z","body":"Hitting this one to =/"}}