topic Load numbers before letters in App Development

Load numbers before letters

DEMONIO_AZUL — Tue, 25 Jun 2024 15:56:03 GMT

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 — Tue, 25 Jun 2024 18:31:00 GMT

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 — Thu, 04 Jul 2024 08:38:31 GMT

You can perhaps sort them that you wish?

DEMONIO_AZUL — Thu, 04 Jul 2024 12:42:03 GMT

Thanks, this works!