Skip to main content
Panther Knowledge Base

My CSV of Data Explorer results from Panther contains unnecessary double quotes

  1. Last updated
  2. Save as PDF

QUESTION

When we export query results from Data Explorer as a CSV file, there are a lot of unnecessary double quotes. Why does this happen?

ANSWER

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""".