Formating .csv files on a Mac
 16 years
|
I tried to combine five of the outlet mall POI's using Excel. When I tried to convert the .csv file to a .gpx file using csv2gpx, it did so but when I tried to import the .gpx into RoadTrip (which is why I did the conversion in the first place) Road Trip told me it was not a proper file and would not import it. After fooling around with the files, I finally took the data into good old Appleworks and a formating figure that looks like a square O showed up for what looked to be a formating character in some program for a line return. When I removed this character, the file would convert properly and import into RoadTrip. The strange thing about this symbol is that I could not copy it and use the find and replace option in Appleworks, I had to eliminate it manually.
My question is does anyone know where this character comes from, why is it there, why can't I copy it and why doesn't it show up in Excel, but does in Appleworks when I copy the data over? Thanks for any information you can give me.
strange character
I would suggest that you open the csv file with a text editor and see if the character exist. If it doesn't run the file through the conversion w/ csv2gpx program. Check the resulting gpx file if the character shows up. This will let you eliminate whether it's a bad csv file or something with the csv2gpx program.
nuvi 2460LMT
Linebreaks
I tried to combine five of the outlet mall POI's using Excel. When I tried to convert the .csv file to a .gpx file using csv2gpx, it did so but when I tried to import the .gpx into RoadTrip (which is why I did the conversion in the first place) Road Trip told me it was not a proper file and would not import it. After fooling around with the files, I finally took the data into good old Appleworks and a formating figure that looks like a square O showed up for what looked to be a formating character in some program for a line return. When I removed this character, the file would convert properly and import into RoadTrip. The strange thing about this symbol is that I could not copy it and use the find and replace option in Appleworks, I had to eliminate it manually.
My question is does anyone know where this character comes from, why is it there, why can't I copy it and why doesn't it show up in Excel, but does in Appleworks when I copy the data over? Thanks for any information you can give me.
That character is a standard linebreak. Most of the Outlet Mall csv files do have linebreaks. Many programs won't tolerate linebreaks; and, therefore, the linebreaks have to be removed. This can be done manually; or can be removed easily with http://PoiVerifier.com
They do show up in Excel as a linebreak. Click on a field 4 entry in Excel and it will display multiple lines divided at these linebreaks.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
Have you made a Mac version?
Your program is a great tool - but the original poster is working on a Mac - maybe he uses VM-Ware or Parallels and has windows running on the mac and can make use of PoiVerifier.
*Keith* MacBook Pro *wifi iPad(2012) w/BadElf GPS & iPhone6 + Navigon*
If ...
geochapman, if you would tell me which csv Outlet POIs you're using, I'll remove the linebreaks for you and send them to you via email. Just send me an email address that accepts attachments.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
I removed the symbol
I guessed that this was a line break and have removed them myself. I do not have windows on my Mac so can't run POiverifier but I was looking for confirmation of my suspecions. Thanks all for your answers.
NUVI 660, Late 2012 iMac, Macbook 2.1 Fall 2008, iPhone6 , Nuvi 3790, iPad2
convert file types
The best tool I've found is GPS Babel. It can convert to almost anything including into and out of Google maps.
http://www.gpsbabel.org/download.html