I need a CHANGE to be able to produce a more pure CVS file, as the format for Columbus V900 uses a text format for the latitude and longitude. 9.123456N and -79.123456W are what are in the Columbus format. I need a pure Number in each of these, as the N and W are actually redundant, and because of them I cannot do -.0006 to the longitude in the Panama Canal track, since the W at the end makes the track a text position and not a purely numerical position.
Then I need to be able to take that modified CVS file and bring it back into RouteConverter so I can save it as a GPX file for use with the GPicSync program as I geocode my photos.
I would also be able to sort on the date and time columns to catch sequencing errors. I would be able to delete a range where the movement is incorrectly recorded, and let Excel or QuatroPro fill in the values for the correct increments in latitude and longitude when that is appropriate, instead of having to insert one at a time, and keep moving the position I am injecting at to cover all of the missing points that I deleted and need to replace. I could even merge several files that way while I fill in the missing 'seconds'... so I can see lots of uses for that pure CSV format.
Then I need to be able to take that modified CVS file and bring it back into RouteConverter so I can save it as a GPX file for use with the GPicSync program as I geocode my photos.
I would also be able to sort on the date and time columns to catch sequencing errors. I would be able to delete a range where the movement is incorrectly recorded, and let Excel or QuatroPro fill in the values for the correct increments in latitude and longitude when that is appropriate, instead of having to insert one at a time, and keep moving the position I am injecting at to cover all of the missing points that I deleted and need to replace. I could even merge several files that way while I fill in the missing 'seconds'... so I can see lots of uses for that pure CSV format.