When we export query results from Data Explorer as a CSV file, there are a lot of unnecessary double quotes. Why does this happen?
This representation is actually a result of the CSV code syntax. The first double quote marks the beginning of the field value, while the last double quote marks the end.
Also, in CSV, if a field’s value contains a double quote character it is escaped by placing another double quote character next to it. As a result, in order to represent the String value"my_value" the outcome in CSV will be"""my_value""".