Home » Welcome / open talk

CSV file to large for Google Maps

 
Fri, 05/25/2018 - 8:57am

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

‹ Amazon Devices Recorded Couple’s Home Chats Then Sent to Random Contact Contributors Of The Week 2018-05-14 ›
Fri, 05/25/2018 - 9:01am

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
Sat, 05/26/2018 - 7:43pm

Is there a way to do this

Is there a way to do this without appending each entry? I use note pad.

Sat, 05/26/2018 - 8:11pm

I used Google Spreadsheet

I used Google Spreadsheet and deleted column D for all entries. That worked, thanks.

Sun, 05/27/2018 - 12:16am

Use FIND

timjet wrote:

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 DriveSmart 76 Williamsburg, VA
Sun, 05/27/2018 - 8:29am

Thanks. I'm not a confident

Thanks. I'm not a confident spreadsheet user. Thanks for that tip.