SimplyPats User Forum

SimplyPats Portable Appliance Testing Software
It is currently Sun Feb 17, 2019 9:27 pm

All times are UTC [ DST ]

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

Joined: Wed Jan 23, 2008 11:47 pm
Posts: 1104
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.


If you use all alpha appliance id's.

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


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


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


A New Sort Order Appliance Id (Converted Numeric)

File comment: Sorting Alpha Numeric Appliance Id's
new sort order.jpg
new sort order.jpg [ 56.72 KiB | Viewed 3848 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.

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:  
Powered by phpBB® Forum Software © phpBB Group