I am working on linguistic analyses on Programmers. I am running a query in the Data Explorer that grabs all the user information. The query is the following:
select * from Users;
The query is fine but some fields include commas, which messes up the CSV when I try to import it into Excel. How would you modify the query so that commas could be replaced by something else such as a space?
""
as an escape for an embedded double-quote, so it might be sensible if Data Explorer handled that itself (or allowed for it to be configurable).