Sort Alpha Numbers

[ariel_klien]

Hello all Experts,

I have filed with codes that include numeric and alpha .

How can I sort them in a chart like this:

01

02

03

..

..

18

19

1A

1B

1C

20

21

23

..

..

29

2A

2B

And so on....

I attached a file with the codes

Thanks,

Ariel

[nagireddy_qv]

Hi

Please find the attached sample file..

[ariel_klien]

Hi nagireddy.qv

Thanks for the quick answer.

But as you can see in the example. this is not what i need.

i need that code '1A' will be after code '19' and not after code '99'

Ariel

[kaushiknsolanki · Accepted solution]

Hi,

Try this code.

Directory;

LOAD Code,

  Ord(Left(Code,1)) + (Ord(Right(Code,1))/100) as Sort

FROM

Codes.xlsx

(ooxml, embedded labels, table is Sheet1);

Use Sort Fields in sorting tab of property and use expression sort functionality.

Regards,

Kaushik Solanki

[ariel_klien]

Works.

Thanks.