[Rellwood]

I use Ablebits Excell add-ons to help with my Goodreads Library Export csv which I format and using import list, get my current shelves and other info up to date. I also use a small .exe file I got from GitHub that is a Goodreads CSV extender which after pointing it to a recent Goodreads export it will chug away and tack on to the end of each row all the genres (popular shelves) and dates read (multiple dates) for each book.

So between those two things I get spectacular data to enter into Calibre. However, I just realized that I was deleting some numbers that I needed.

This is how the genres are displayed at the end of the row:

Horror|470;Fiction|73;Thriller|21;Science Fiction|9;Audiobook|8;Animals|6;European Literature,British Literature|5;Fantasy|5;Novels|5;Apocalyptic,Post Apocalyptic|4

The numbers represent the number of people who shelved the book with that genre.

With Ablebits I was just mass formatting the column by deleting all the numbers and the "|" and find/replace the semicolons and commas.

It turns out that I was deleting all the 15th Century, 16th Century, etc. and leaving ",th Century" behind.

Ablebits has a regex function to find and remove substrings within a cell.

So I would like to know if there is a regex expression that would include all the numbers between that "|" and a semicolon.

Sorry so long...