How to sort by - symbol

[Lucky1]

Hi

countryacronym field with values

US.ICE-FUTURES

US.Future

US-Miam

US.mik

I want to sort this by symbol like (.) should be 1st position  and _ should be last

Need my output like

CountryAcronym--this is my field name

US.Future

US.mik

US.ICE-FUTURES

US-Miam

[vinieme12]

updated solution, slight change in logic

Load
Ticker
,if(index(Ticker ,'-'),2,1)&Ord(upper(Ticker))&Ord(coalesce(subfield(upper(Ticker),'-',2),subfield(upper(Ticker),'.',2))) as Ticker_Sort_Order
inline [
Ticker
US.FR
US.MGE
US.NF
US.OC
US-IL.IDFP
US.CBO
US.CM
US.DTC
US.FINR
];