Batch renaming waypoints

Discussion in 'GPS Software' started by talkgloc, Nov 29, 2019.

  1. talkgloc

    talkgloc

    Joined:
    Nov 19, 2019
    Messages:
    5
    Likes Received:
    0
    Hello all,

    I've done some searching here and on the web but haven't found specifically what I'm looking for.

    I'm looking for an application, Mac or PC based is fine, that will batch rename all my waypoints for a specific route. For example I have a trip coming up to take the train to Washington DC from close to my residents and it has over 600 way points in it. What I would like is instead of the generic name that GPS Visualizer gives them to something like ARR#### (A for Amtrak, RR for route number and #### for an incremented number).

    Does such an application exist?

    Thank you for your help
     
    talkgloc, Nov 29, 2019
    #1
    1. Advertisements

  2. talkgloc

    Nuvi-Nebie Moderator

    Joined:
    Aug 16, 2015
    Messages:
    1,238
    Likes Received:
    112
    Location:
    UK
    If you can convert a GPX file containing your waypoints to CSV (Comma Seperated Variable) format you can use Microsoft Excel to convert a block of text into a new format :-

    rename1.jpg

    Above is a screen capture of a CSV file loaded into Excel, the 20 names were auto named by Garmin Basecamp

    rename2.jpg

    I changed the first two 'Names' to a string of letters and numbers ending in '000' and '001'

    rename3.jpg
    By highlighting the first two 'Names' and then dragging the box from the bottom right corner to cover all 20 (or 600 in your case), it is possible to get Excel to replace the text and auto number each Name as above
     
    Nuvi-Nebie, Nov 29, 2019
    #2
    talkgloc likes this.
    1. Advertisements

  3. talkgloc

    talkgloc

    Joined:
    Nov 19, 2019
    Messages:
    5
    Likes Received:
    0

    Thank you, I'll give this a try.
     
    talkgloc, Nov 29, 2019
    #3
  4. talkgloc

    talkgloc

    Joined:
    Nov 19, 2019
    Messages:
    5
    Likes Received:
    0

    Worked like a champ!!
     
    talkgloc, Nov 30, 2019
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.