Sorting via specifics

Hi everyone,

My excel skills aren’t the greatest, so any help would be appreciated.
I’m trying to see if there is a way to sort the data I have by 2 conditions, firstly alphabetically, and then by a specific character within the cell, in a specific order. The cells contain an inconsistent character length, but all have the same suffix, so could this potentially be done using the “RIGHT()” function?

The column contains a text line such as: southbank_3006,400iol-z19R,-----H
I want to sort alphabetically via location (which is southbank in this example), which will use the first character, but then via a specific order for the 11th character from the right: z
The desired order will be _ O I Z Y X W A B, as these are the only characters used.
So if I have multiple entries they would appear in this order:
southbank_3006,400iol-_19R,-----H
southbank_3006,400iol-o19R,------
southbank_3006,400iol-y19R,-----H
southbank_3006,400iol-x19R,-----H
southbank_3006,400iol-a19R,------
southbank_3006,400iol-b19R,-----H
stkilda_3182,200llr-_16R,-H----
stkilda_3182,400iol-w19R,-H----

Is this possible, or have I hit a dead end?

Thanks heaps protonLeah. This worked. I had to modify the strings a little, but I got the end result.