Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi
Please find the attached sample file..
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
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
Works.
Thanks.