Return to Project-GC

Welcome to Project-GC Q&A. Ask questions and get answers from other Project-GC users.

If you get a good answer, click the checkbox on the left to select it as the best answer.

Upvote answers or questions that have helped you.

If you don't get clear answers, edit your question to make it clearer.

Copy and Paste with only one " in Cache name

0 votes
75 views
When I copy and paste into an excel spreadsheet, a list created in BETA Virtual-GPS, a single quotation mark (like "Korth Trailhead View) places all of the following cache info into a single cell until another cache with a quotation mark is found.  Doesn't seem to be a problem when the info is exported as a CSV file.
asked Feb 25, 2015 in Bug reports by PYC (140 points)

3 Answers

0 votes
Unless I misunderstand what you mean, that sounds like a problem with Excel.
answered Feb 25, 2015 by pinkunicorn (Moderator) (148,800 points)
0 votes
Have not used excel but in libre office you can select what characters are delimiters when loading csv. There probably exist options like that excel.  
 
csv=Comma-separated values defined in http://tools.ietf.org/html/rfc4180
 
The name cache line is as below and " is escaped as "" like the standard describes. The problem is with the excel import not with the csv.
 
GC1DRH3,"""Korth Trailhead View","Traditional Cache",Regular,2.0,2.0,rez_jay,47.053567,-116.960117,"United States",Idaho,"Latah County (ID)",0,0,0
 
Try to open the csv file with excel instead of pasting the datat into it it might help. Libre office give options for delimitere on both paste and open
answered Feb 25, 2015 by Target. (Expert) (104,060 points)
0 votes

I haven't used excel for many years. But I remember there being a difference between these two:

  1. Open file, choose csv file
  2. Create empty spread sheet, data, import data, choose csv file

The later one gives more options, which might help. As others have stated, the csv file itself is correct, the issue is with the import.

answered Feb 25, 2015 by magma1447 (Admin) (219,030 points)
...