RetroPie forum home
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Home
    • Docs
    Please do not post a support request without first reading and following the advice in https://retropie.org.uk/forum/topic/3/read-this-first

    Game list Only title.

    Help and Support
    retropie help emulationstatio romset
    4
    6
    245
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Peppe_H
      Peppe_H last edited by

      good evening, I would like to know if there is a method to create a list of the titles of the roms in the folder or on the gamelist.xml file without other information but only with the title of the game.
      thank you for the reply.

      IanDaemon muldjord 2 Replies Last reply Reply Quote 0
      • IanDaemon
        IanDaemon @Peppe_H last edited by IanDaemon

        @peppe_h Where do you want the list? You can take the XML in Microsoft Excel and grab the game titles easily with formulas.

        • 5 Favorite Arcade Games in MAME
        • Cocktail Cabinet Games
        • Check out the MAME RoW
        Peppe_H 1 Reply Last reply Reply Quote 0
        • Peppe_H
          Peppe_H @IanDaemon last edited by

          @iandaemon what formula could i apply with excel?

          IanDaemon 1 Reply Last reply Reply Quote 0
          • IanDaemon
            IanDaemon @Peppe_H last edited by IanDaemon

            @peppe_h Wow, that's even easier than I thought! I was going to suggest using the MID and FIND functions with a helper cell, but I just took my arcade gamelist.xml file and opened it in Excel. Microsoft Excel didn't see a reference to a schema/structure in the file so it attempted to create one based on the data. BAM!, it made a table with all the data in cells and columns. Here's a portion of a screenshot:

            ac5d3f1b-1bb1-44f1-a505-3e2f691bf20d-image.png

            FWIW, I was going to suggest something like a recent situation where I extracted data from a string in a web-based database application: =MID(Preview_Files,FIND("front\":\"http",Preview_Files)+8,(FIND("back",Preview_Files)-FIND("front\":\"http",Preview_Files))-11) BUT you don't have to do this if Excel does everything for you.

            • 5 Favorite Arcade Games in MAME
            • Cocktail Cabinet Games
            • Check out the MAME RoW
            MrPacMan17 1 Reply Last reply Reply Quote 0
            • MrPacMan17
              MrPacMan17 @IanDaemon last edited by

              @iandaemon Hi, why not use this Gamelist Excel export script? Works great! https://retropie.org.uk/forum/topic/16319/gamelist-excel-export-script

              1 Reply Last reply Reply Quote 0
              • muldjord
                muldjord @Peppe_H last edited by

                @peppe_h

                Run this from any platform folder on the RetroPie:

                cat gamelist.xml | grep '<name>' | cut -d '>' -f2 | cut -d '<' -f1 > titles.txt
                

                It will export all titles to titles.txt

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post

                Contributions to the project are always appreciated, so if you would like to support us with a donation you can do so here.

                Hosting provided by Mythic-Beasts. See the Hosting Information page for more information.