If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Attn: Marshall Barton
On Mon, 24 Sep 2007 18:15:41 -0400, Tom wrote:
Chuck, Here that file with everything sorted. Thanks Part Num,L,M,R 1.1,#a,#,s 1.11,#a,##,s 1.111,#a,###,s 1.1111,#a,####,s 1.11111,#a,#####,s 11.1,##a,#,s 11.11,##a,##,s 11.111,##a,###,s 11.1111,##a,####,s 11.11111,##a,#####,s 111.1,###a,#,s 111.11,###a,##,s 111.111,###a,###,s 111.1111,###a,####,s 111.11111,###a,#####,s 1-1,#a,#,s 1-11,#a,##,s 1-111,#a,###,s 1-1111,#a,####,s 1-1111A,#a,####,a 1-1111AA,#a,####,aa 11-11A12,##a,##,a## 11-111A12,##a,###,a## 111-1,###a,#,s 111-11,###a,##,s 111-111,###a,###,s 111-1111,###a,####,s 111-1111A,###a,####,a 111-1111AA,###a,####,aa 111-1111AAA,###a,####,aaa 111-11111,###a,#####,s 111-11111A,###a,#####,a 111-11111AA,###a,#####,aa 111-11111AAA,###a,#####,aaa 111-D1,###a,a#,s 111-D11,###a,a##,s 111-D111,###a,a###,s 111-D1111,###a,a####,s 11A1,##a,#,s 11A11,##a,##,s 11A11A,##a,##,a 11A11AA,##a,##,aa 11A111,##a,###,s 11A111A,##a,###,a 11A111AA,##a,###,aa 11A1111,##a,####,s 11A1111A,##a,####,a 11A1111AA,##a,####,aa 15-1,##a,#,s 15-11,##a,##,s 15-11A,##a,##,a 15-111,##a,###,s 15-111A,##a,###,a 15-1111,##a,####,s 15-1111A,##a,####,a 15-1111AA,##a,####,aa 15-11111,##a,#####,s 15-11111A,##a,#####,a 15-111111,##a,######,s 15-111111A,##a,######,a 1PG,s,#,aa 11,s,##,s 11N,s,##,a 11PG,s,##,aa 33APG,s,##,aaa 111,s,###,s 111APG,s,###,aaa 111N,s,###,a 111PG,s,###,aa 1111,s,####,s 1111APG,s,####,aaa 1111PL,s,####,aa 1111PLA,s,####,aaa 1111R,s,####,a 11111,s,#####,s 11111PL,s,#####,aa 11111PLA,s,#####,aaa 11111R,s,#####,a 111111,s,######,s 1111111,s,#######,s 1111111A,s,#######,a 111111PL,s,#######,aa 111111PLA,s,#######,aaa 111111R,s,#######,a 11111111,s,########,s 761-1,aaaa,#,s 761-11,aaaa,##,s 761-111,aaaa,###,s 761-1111,aaaa,####,s 761-1111A,aaaa,####,a 761-1111AA,aaaa,####,aa 761-11111,aaaa,#####,s 761-1111111,aaaa,#######,s B-111,aa,###,s B-1111,aa,####,s BAL-111,aaaa,###,s BD1,aa,#,s BD1M,aa,#,a BD11,aa,##,s BD11BM,aa,##,aa BD11M,aa,##,a BD11ABC,aa,##,aaa BD111,aa,###,s BD111BM,aa,###,aa BD111M,aa,###,a BD1111,aa,####,s BD1111AM,aa,####,aa BD1111C,aa,####,a H11,a,##,s H11A,a,##,a H111,a,###,s H111-2,a,###,a# H111A,a,###,a H111AC,a,###,aa H1111,a,####,s H1111-2,a,####,a# H1111A,a,####,a H1111AC,a,####,aa H11111,a,#####,s H11111-2,a,#####,a# H11111A,a,#####,a H11111AA,a,#####,aa H111111,a,######,s H111111A,a,######,a H111111R,a,######,a HP-11111.1,aaa,#####,a# MC11111,aa,#####,s MC111111,aa,######,s MC111111A,aa,######,a PGD1,aaa,#,s PGD1M,aaa,#,a PGD11,aaa,##,s PGD11BM,aaa,##,aa PGD11BMA,aaa,##,aaa PGD11M,aaa,##,a PGD111,aaa,###,s PGD111BM,aaa,###,aa PGD111BMA,aaa,###,aaa PGD111M,aaa,###,a PGD1111,aaa,####,s PGD1111AM,aaa,####,aa PGD1111AMA,aaa,####,aaa PGD1111C,aaa,####,a PGD11111,aaa,#####,s PGD111111,aaa,######,s RC1111QS,aa,####,aa RC11111A,aa,#####,a RC11111ANS,aa,#####,aaa RC11111NS,aa,#####,aa SNA6A24D,aaa,#,a##a SNA6A2D,aaa,#,a#a SSRD2,aaaa,#,s SSRD52,aaaa,##,s SSRD52M,aaaa,##,a SSRD552,aaaa,###,s SSRD552M,aaaa,###,a SSRD5521,aaaa,####,s SSRD5521M,aaaa,####,a T1PG,a,#,aa T11PG,a,##,aa T33APG,a,##,aaa T111APG,a,###,aaa T111PG,a,###,aa T1111APG,a,####,aaa T11111APG,a,#####,aaa T11111PG,a,#####,aa TSSRD20,aaaaa,##,s TSSRD20A,aaaaa,##,a TSSRD200,aaaaa,###,s TSSRD200A,aaaaa,###,a ,,, whe,,, ,# is any digit,, ,a is any nondigit,, ,s is just spaces (i.e empty),, On Sun, 23 Sep 2007 17:39:49 -0400, Chuck wrote: On Sun, 23 Sep 2007 16:37:25 -0400, Tom wrote: Chuck, No, the part numbers are not interchangeable. Yes, they are from other organizations as well as my own. Not sure what you mean by unbreakable UDF. Thanks Big snip Would you please re-post your list of Part Num(s) sorted exactly the way you want them. Possibly with the *answer* to your question, a set of equations can be devised that will produce that *answer*. Chuck Sorting as above looks straight forward, but it isn't. You want to sort 111.11111 before 1-1. It is possible, but will require more complex equations than I'm willing to spend the time developing. When you get to the second character and it is not a period or dash, you have to examine the next several characters to see if there is a period or dash latter on in the sequence. Also, what happens when someone starts using / \ ! ; : or , for separators? (by the way, dashes are naturally sorted before periods) There are probably others reading this news group who are a lot smarter than I am and who can write the equations "of the top of the head'. Sorting as below is quite easy. Notice that all the 1. and 1- are sorted before Part Numbers that start with several numeric characters. 1.1,#a,#,s 1.11,#a,##,s 1.111,#a,###,s 1.1111,#a,####,s 1.11111,#a,#####,s 1-1,#a,#,s 1-11,#a,##,s 1-111,#a,###,s 1-1111,#a,####,s 1-1111A,#a,####,a 1-1111AA,#a,####,aa 1-123-1,#a,###,a# 11,s,##,s 11.1,##a,#,s 11.11,##a,##,s 11.111,##a,###,s 11.1111,##a,####,s 11.11111,##a,#####,s 11-111A12,##a,###,a## 11-11A12,##a,##,a## 111,s,###,s 111.1,###a,#,s 111.111,###a,###,s 111.11111,###a,#####,s 111.1111,###a,####,s 111.11,###a,##,s 111-1,###a,#,s 111-1111,###a,####,s 111-111,###a,###,s 111-11,###a,##,s 111-1111A,###a,####,a 111-11111,###a,#####,s 111-11111AAA,###a,#####,aaa 111-1111AA,###a,####,aa 111-1111AAA,###a,####,aaa 111-11111A,###a,#####,a 111-11111AA,###a,#####,aa 111-D111,###a,a###,s 111-D1111,###a,a####,s 111-D11,###a,a##,s 111-D1,###a,a#,s 1111,s,####,s 11111,s,#####,s 111111,s,######,s 1111111,s,#######,s 1111111A,s,#######,a 111111R,s,#######,a 111111PL,s,#######,aa 111111PLA,s,#######,aaa 11111111,s,########,s 11111PL,s,#####,aa 11111PLA,s,#####,aaa 11111R,s,#####,a 1111APG,s,####,aaa 1111PLA,s,####,aaa 1111PL,s,####,aa 1111R,s,####,a 111APG,s,###,aaa 111N,s,###,a 111PG,s,###,aa 11A1,##a,#,s 11A11,##a,##,s 11A1111AA,##a,####,aa 11A111,##a,###,s 11A111AA,##a,###,aa 11A1111,##a,####,s 11A1111A,##a,####,a 11A111A,##a,###,a 11A11AA,##a,##,aa 11A11A,##a,##,a 11N,s,##,a 11PG,s,##,aa 14-123-12,##a,###,a## 15-1,##a,#,s 15-11,##a,##,s 15-11111,##a,#####,s 15-111,##a,###,s 15-111A,##a,###,a 15-1111,##a,####,s 15-1111AA,##a,####,aa 15-11111A,##a,#####,a 15-111111,##a,######,s 15-111111A,##a,######,a 15-1111A,##a,####,a 15-11A,##a,##,a 1PG,s,#,aa 33APG,s,##,aaa 761-1,aaaa,#,s 761-11,aaaa,##,s 761-111,aaaa,###,s 761-1111,aaaa,####,s 761-1111A,aaaa,####,a 761-1111AA,aaaa,####,aa 761-11111,aaaa,#####,s 761-1111111,aaaa,#######,s B-111,aa,###,s B-1111,aa,####,s BAL-111,aaaa,###,s BD1,aa,#,s BD11,aa,##,s BD111,aa,###,s BD1111C,aa,####,a BD1111AM,aa,####,aa BD1111,aa,####,s BD111BM,aa,###,aa BD111M,aa,###,a BD11BM,aa,##,aa BD11M,aa,##,a BD1M,aa,#,a BS11ABC,aa,##,aaa H11,a,##,s H111,a,###,s H111-2,a,###,a# H1111,a,####,s H1111-2,a,####,a# H111111R,a,######,a H11111,a,#####,s H11111-2,a,#####,a# H11111AA,a,#####,aa H111111,a,######,s H111111A,a,######,a H11111A,a,#####,a H1111A,a,####,a H1111AC,a,####,aa H111A,a,###,a H111AC,a,###,aa H11A,a,##,a HP-11111.1,aaa,#####,a# MC111111A,aa,######,a MC111111,aa,######,s MC11111,aa,#####,s PGD1,aaa,#,s PGD11,aaa,##,s PGD111BM,aaa,###,aa PGD111,aaa,###,s PGD111BMA,aaa,###,aaa PGD111M,aaa,###,a PGD1111,aaa,####,s PGD1111C,aaa,####,a PGD1111AM,aaa,####,aa PGD1111AMA,aaa,####,aaa PGD11111,aaa,#####,s PGD111111,aaa,######,s PGD11BM,aaa,##,aa PGD11BMA,aaa,##,aaa PGD11M,aaa,##,a PGD1M,aaa,#,a RC11111ANS,aa,#####,aaa RC11111A,aa,#####,a RC11111NS,aa,#####,aa RC1111QS,aa,####,aa SNA6A24D,aaa,#,a##a SNA6A2D,aaa,#,a#a SSRD2,aaaa,#,s SSRD52,aaaa,##,s SSRD52M,aaaa,##,a SSRD552,aaaa,###,s SSRD5521M,aaaa,####,a SSRD5521,aaaa,####,s SSRD552M,aaaa,###,a T11111APG,a,#####,aaa T11111PG,a,#####,aa T1111APG,a,####,aaa T111APG,a,###,aaa T111PG,a,###,aa T11PG,a,##,aa T1PG,a,#,aa T33APG,a,##,aaa TSSRD200A,aaaaa,###,a TSSRD20A,aaaaa,##,a TSSRD20,aaaaa,##,s TSSRD200,aaaaa,###,s |
Thread Tools | |
Display Modes | |
|
|