Extract everything after 2nd last / in a string in microsoft excel

I have a bunch of URLs with different lengths and folder paths. I wish to extract everything after the 2nd last / in them.

The example URLs:

https://www.example.com/folder1/folder2/folder3/path-name-here/12345678/
https://www.example.com/folder1/folder2/path-name-here/39089/

The output should be:

12345678
39089

I have tried a bunch of different functions but no luck so far so would appreciate if someone can support.

>Solution :

Another alternative:

=TEXTBEFORE(TEXTAFTER(A1,"/",-2),"/")