AnsweredAssumed Answered

Sorting Vacuum Tube Numbers

Question asked by elliott6621 on Dec 2, 2016
Latest reply on Dec 4, 2016 by Tom_Droz

I have a db that keeps track of my vacuum tube inventory. When I sort by tube number, the order is not really by tube number.

Example:

0Z4

12AD6

12B4

12SA7

19T8

1V2

24A

35W4

3AL5

50L6GT

5CL8A

6146

6AB4

8032

 

1V2 should be just below the 0Z4, and the 3AL5 would be next. The 6146 should be next to last.

 

Tube numbers will start with 1 or 2 digits, followed by letters, or be 4 digits. I tried unicode sorting but no effect.

1 record for each tube, 1 field containing the tube number. Other fields in the record are for location, condition, cost, etc.

Finding records by tube number is of course easy, but printed out lists are not correct.

I could use a script but not sure where to start. There are about 300 different numbers in this database.

Any help appreciated.

 

Thanks

Outcomes