Skip to main content
20 events
when toggle format what by license comment
Jun 6, 2018 at 4:40 history tweeted twitter.com/StackGIS/status/1004221444472098817
May 24, 2018 at 23:27 history edited Waterman CC BY-SA 4.0
Changed Title to more accurately reflect what turned out to be the problem / solution.
May 24, 2018 at 23:18 vote accept Waterman
May 24, 2018 at 3:09 answer added user2856 timeline score: 7
May 24, 2018 at 1:47 answer added Michael Stimson timeline score: 0
May 24, 2018 at 1:45 comment added Waterman @Luke Understood. Nonetheless, my real CSV has Lng and Lat columns and does produce the above error, which specifically complains about the 14th value in the "Comments" column. Seemed like Vince's suggestion that it has to do with the CSV converter not escaping single apostrophes was a good lead...?
May 24, 2018 at 1:24 comment added Waterman @Luke. I just pasted that column in my question as it appears in Notepad. Looks pretty much the same to me.
May 24, 2018 at 1:23 history edited Waterman CC BY-SA 4.0
added 22 characters in body
May 24, 2018 at 1:17 comment added Waterman @Luke Done. Hope that suffices.
May 24, 2018 at 1:16 history edited Waterman CC BY-SA 4.0
added relevant column of CSV file
May 24, 2018 at 1:01 history edited Waterman CC BY-SA 4.0
added 3 characters in body
May 24, 2018 at 0:53 history edited Waterman CC BY-SA 4.0
added 3 characters in body
May 24, 2018 at 0:42 history edited PolyGeo
edited tags
May 24, 2018 at 0:42 comment added Waterman @Luke Code snippet added. What is the best way for me to share the section of CSV you requested?
May 24, 2018 at 0:41 history edited Waterman CC BY-SA 4.0
Added code and updated question
May 24, 2018 at 0:40 history edited PolyGeo
edited tags
May 24, 2018 at 0:18 comment added Michael Stimson You could find and replace in the file ''' with '~' before loading then field calc '~' to ''' with a single replace statement after loading... assuming ~ is not already in the file.
May 24, 2018 at 0:01 comment added Waterman I wondered about that. The only problem is this is from a "comments" column and P'tit is part of a legitimate place name entered by someone else. I need every character in the comments field to be transferred. I will ask this in a new question.
May 23, 2018 at 23:55 comment added mkennedy You've got a single quote in "P'tit".
May 23, 2018 at 23:39 history asked Waterman CC BY-SA 4.0