Extract specific text following a specific character from right to left

Hello,

I'm interested in finding a function that will help me extract a specific text that sits just before a specific character. However, the challenge is that my text strings are of various sizes and it would require identifying the last "#" and extracting the value that sits just before that character.

As an example:
Screenshot 2024-02-14 103153.png


From the example above, I will need to extract the values that are in green.

Any ideas how to tackle this one?

Thanks in advance!