SimplyPats User Forum

SimplyPats Portable Appliance Testing Software
It is currently Sat Dec 16, 2017 12:46 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Mon Sep 14, 2015 1:20 pm 
Offline
Site Admin
User avatar

Joined: Wed Jan 23, 2008 11:47 pm
Posts: 1087
Location: Cornwall
Sorting Alpha Numeric Appliance Id's on Printed Reports

There are several options to determine the Sort Order of Appliance Id's on Printed reports within SimplyPats 7

    Appliance Id (Numbers)
    Appliance Id (Letters)
    Appliance Id (Strict)

and in the majority of cases these give the desired sort order of appliance id's within the reports

If you use all numeric appliance id's.

Computers have no issues in sorting these e.g.

    0050791
    0050792
    0050793

If you use all alpha appliance id's.

Again, computers have no issues in sorting e.g.

    ABCDD
    ABCDE
    ABCDF

Alpha Numeric appliance id's.

Whilst we maybe able to look at alpha numeric appliance id's and know the order that we would like them sorted

    ABC90001
    ABC90002
    ABC90003
    ABC90004
    ABC90005
    ABC90006
    ABC90007
    ABC90008
    ABC90009
    ABC90010

The computer cannot determine these appliance id's as numbers and so sorts them as alpha's
This gives the undesirable results below, where app id 1 and app id 10 get sorted together

    ABC0001
    ABC90010
    ABC90002
    ABC90003
    ..etc

A New Sort Order Appliance Id (Converted Numeric)

Attachment:
File comment: Sorting Alpha Numeric Appliance Id's
new sort order.jpg
new sort order.jpg [ 56.72 KiB | Viewed 3065 times ]


In SimplyPats Version 7.0.7 we have added a new sort order 'Appliance Id (Converted Numeric)'

If this sort order is selected, Appliance Id's that contain preceding letters e.g. ABC90010 will be converted into a hidden column of numbers e.g. 90010 and sorted by that column.

The full alpha numeric appliance id will of course be shown on the reports.

This will then give the desired sorted result of ABC90001 to ABC90010

Note 1.

Be aware that this requires the computer to do a large number of calculations as it looks at each appliance id in turn to find the numeric part of the number in order to store it as a hidden key for the sort.
On SimplyPats files with large numbers of appliances this may take some time to calculate so you might need to be be patient.

Note 2. This sort order cannot cater for situations where words are in the middle 90010ABC or at the end 900ABC10 of the appliance id.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group