Regex Help Please??

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

[Karellen]

This should find the pipe, digits and semi-colon

PHP Code:

\|\d+; 


Then replace with nothing.

[DNSB]

I would suggest replacing with a ; instead of nothing. Perhaps leaving the ; out to allow catching the last item in the list which is not terminated by a ;?

[theducks]

Originally Posted by DNSB

I would suggest replacing with a ; instead of nothing. Perhaps leaving the ; out to allow catching the last item in the list which is not terminated by a ;?

or
;* (0 or more)

[Rellwood]

The reason I get rid of the ; is because I transform it into a coma.

What starts out as

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

Ends up as

Horro, Fiction.Thriller, Science Fiction, Audiobook, Animals, European Literature.British Literature, Fantasy, Novels, Apocalyptic.Post Apocalyptic

I have heriarchal shelves.

The steps for formatting have been:
Delete numbers (single step)
Delete the divider
Find/Replace , to .
Find/Replace ; to ,