Return the searched substring from the string

[Connor_Slevin]

I have a dimension with the naming convention: market_region_operating system_date

I want to extract the operating system into its own dimension but cannot use the substring function as the number of character prior to the operating system varies and thus there is not one solid start_position to work with.

However, there is a consistent number of underscores before operating system.

Any advice?