How to sort by symbols in table

[Lucky1]

Hi

I have Country acronyms like this

US.FR

US.MGE

US.NF

US.OC

US-IL.IDFP

US.CBO

US.CM

US.DTC

US.FINR

I want to sort this by . and - and alphabetics.I want my output like 

US.CBO

US.CM

US.DTC

US.FINR

US.FR

US.MGE

US.NF

US.OC

US-IL.IDFP

[rubenmarin]

Hi, go into edit mode, select the table, in the properties panel on the right select sort, move the dimension to the first, un check automatic and select the option to sort alphabetic

ally.

[vinieme12 · Accepted solution]

I've changed the logic slightly, bold below 

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
];