Editing NMEA file with Microsoft Excel ?

[seligman]

When I see my NMEA file inside RouteConverter, the "Description" field can be edited. I would like to change this field from Position 1, Position 2, etc to the Speed value attached to every waypoint. Because my file has 12,000 points this isn't something I want to do manually.

I'm hoping this can be achieved in Microsoft Excel by first converting the data to .CSV and replacing the default description values with the speed values in MPH.

My end goal is to have a .KMZ file with waypoints named by the speed at that location, such that the speeds are easy to see by location.

Any suggestions?

[kumo]

Hi seligman, welcome at RouteConverter forum!

• Take a short track for evaluation
• The track should contain Description, Longitude, Latitude and Height information
• Save this track as Columbus V900 Standard (*.csv) format
• Open this file in Excel - all data are shown in one column, comma separated
• Use Excel Data/Text in Columns to split one column into several columns (select commas as separator)
• Copy data of column 'Height' into column 'Vox' (don't copy content of description line)
• Insert new columns between each existing column, fill each field of new columns with one comma
• Mark all existing data and copy the whole stuff into the clipboard
• Use RouteConverter File/New to create a blank file
• Put the curser into the blank position list, press RMB, Insert
• Save the resulting track in *.kmz format
  

[seligman]

Thanks, this seems to work. I had to convert the speeds from km/h to MPH but that was easy.

Now that I have that figured out (thank you!) any chance the Date/Time can be added to the "Description" field for each waypoint in the KMZ file? Or is this much too difficult?

[routeconverter]

(28.11.2011 08:07 AM)seligman Wrote:  Now that I have that figured out (thank you!) any chance the Date/Time can be added to the "Description" field for each waypoint in the KMZ file?

kumo wrote

Quote:Copy data of column 'Height' into column 'Vox' (don't copy content of description line)

Instead of this you need to copy the data of the colums 'Date' and 'Time' into the column 'Vox' (preferably merging the cells before copying them).