search

placemarkt / wiki_coordinates_grabber

MIT License
5 stars 0 forks source link

CSV parsing issues #1

Open chriswhong opened 4 years ago

chriswhong commented 4 years ago

Hi, I was trying to work with the CSV generated by this script and encountered the following issues:

1) There is no header row. I know it's not required, but it would be helpful

2) Leading spaces in front of CSV values are throwing off a go-based CSV parser (it thinks it's a non-quoted value with a quote in it)

Screenshot_10_28_20__10_33_PM

3) Numeric Lat and Lon columns should not be quoted

4) Double quotes in the title and description fields are not escaped "Q407451","Ayla (city)","29.569874","34.987335","Currently "Aqaba", The Hashemite Kingdom of Jordan"

should be

"Q407451","Ayla (city)",29.569874,34.987335,"Currently ""Aqaba"", The Hashemite Kingdom of Jordan"

rkoeze commented 4 years ago

Hi @chriswhong! Thanks for the feedback. Will have fixes in the next couple of days.