Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 155 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

SEDE gives incorrect CSV for linked fields. The first 9 lines from the query where I noticed it:

 User Link,,Reputation
   "title": "",
   "id": 16929
   "title": "Joel Spolsky",
   "id": 4

And it also affects post links:

select id as [Post Link], owneruserid as [User Link] from posts where id=42;​​​​

Post Link,User Link
  "title": "Best way to allow plugins for a PHP application",
  "id": 42
  "title": "Wally Lawless",
  "id": 37
share|improve this question

I just tried this now and got:

User Link,,Reputation
  ""title"": ""John Resig"",
  ""id"": 6524
  ""title"": ""Reto Meier"",
  ""id"": 822

(Note the additional quoting and escaping.)

The second field does not have a column name because it isn't aliased in the source query.

Now, about the JSON-style column results -- is this supposed to be on a single line? This doesn't technically break CSV (or does it?), but it's much harder to process after the fact. Would people prefer it to be on a single line? Please let me know in comments.


User Link,,Reputation
"{""title"": ""John Resig"",""id"": 6524}","59.6","5807"
"{""title"": ""Reto Meier"",""id"": 822}","12.140845","9574"
share|improve this answer
Since I don't see anyone commenting, I'm going to assume the way it is now is sufficient. If you want it changed, file a feature request. :) – Jon Seigel Jul 8 '11 at 23:28

You must log in to answer this question.