need to find the first to last word in a semicolon separated string

[jhalfon]

Hi, I have a string dim that I need to find the first to last word and it’s semicolon separated. Example: List = “once;twice;threetimes;ninetimes;eight;finallist;” I need to return : “eight”

source is BigQuery and the field always ends with a “;”