Game list Only title.

[Peppe_H]

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]

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

[Peppe_H]

@iandaemon what formula could i apply with excel?

[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:

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.

[MrPacMan17]

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

[muldjord]

@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