Load numbers before letters

[DEMONIO_AZUL]

Hello there!

I have a field called "System" that contains the following data: A01,A02,A03, A0x.

No issues loading the data, however, when displaying it -say, a table- it gets displayed as A0x, A01, A02, A03.

A0x should be the last to be shown, not the first. I understand that this is the normal ASCII sequence (letters first).

How can I make the load script to load numbers first? Or at least to show them as required, with A0x at the last position?

Note that A0x may be in whatever place in the list, not necessarily in the first or last position of the table.

Thanks!

[marksouzacosta · Accepted solution]

Hi @DEMONIO_AZUL,

You can try something like this. 99 is any high arbitrary number you can use that you know for sure no other will be higher than it.

LOAD 
Dual(System,If(Match('x',Right(System,1)),99,Num(Right(System,2)))) as System
INLINE [
System
A0x
A01
A02
A03
];

Regards,

Mark Costa

[Anil_Babu_Samineni]

You can perhaps sort them that you wish?

[DEMONIO_AZUL]

Thanks, this works!