Why Do I See Quotation Marks in my Export?

When exporting data from a Query in Virtuous, you may see quotation marks around some of the data in your file, like this:

Screen_Shot_2017-04-10_at_11.06.41_AM.png

The quotes are there to keep your data aligned correctly. Virtuous exports data as a CSV, or comma-separated values, file. CSV is the preferred format for managing and moving data between systems, as others, like Excel, can cause changes to source data. However, since a CSV file uses commas to delineate where one field ends and another begin, having commas within a text field could be problematic. To deal with these embedded commas, CSV files use quotation marks to identify text that should be grouped together, so commas between quotation marks are not read as field separators.

If you need to remove quotation marks from your export, you can do that quickly in Excel, for example, using the Find/Replace function.

First, click on the upper-left corner of the spreadsheet to highlight the entire sheet:

Screen_Shot_2017-04-10_at_11.07.06_AM.png

Then, type Control-F (this works on a Mac as well as PC) to open the Find/Replace dialog box. Type a quotation mark into the "Find" box and leave the "Replace With" box blank.

Screen_Shot_2017-04-10_at_11.07.39_AM.png

Then click "Replace All," and you'll see a popup telling you how many quotation marks were removed from your file. Close the dialog box and the Find/Replace dialog, and you're all set!

Screen_Shot_2017-04-10_at_11.08.00_AM.png

Have more questions? Submit a request

0 Comments

Article is closed for comments.