CSV file to large for Google Maps
Fri, 05/25/2018 - 8:57am
6 years
|
I'm trying to use the Rest stops POI file with Google Maps. When I try to download the rest stops POI file into a new layer in Google Maps I get a failed to download message that states: "The column names cannot be larger than 64 characters or include these characters: *<>{} "
Does anybody have a fix for this?
Thanks, Tim
Open the csv file in a Text
Open the csv file in a Text Editor or in Excell or Libre Office and remove the brackets in the 4th column Header.
Frank DriveSmart55 37.322760, -79.511267
Is there a way to do this
Is there a way to do this without appending each entry? I use note pad.
I used Google Spreadsheet
I used Google Spreadsheet and deleted column D for all entries. That worked, thanks.
Use FIND
I used Google Spreadsheet and deleted column D for all entries. That worked, thanks.
You can also select the "D" column and then press "Ctrl + F". This will bring up the "Find" panel. Then use the "Replace" option to replace the brackets with nothing, therefore deleting them. You'll have to do one bracket at a time as this option is meant to replace "strings", so {} will not work.
Metricman Nuvi 3597 GTM-60 Traffic Receiver Williamsburg, VA
Thanks. I'm not a confident
Thanks. I'm not a confident spreadsheet user. Thanks for that tip.