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 |
#1
|
|||
|
|||
Attn: Marshall Barton
Marsh,
In case you missed my reply, I posted the sort table on 9/15/2007 to your attention. Thx for your help. Tom -- Tom |
#2
|
|||
|
|||
Attn: Marshall Barton
Tom wrote:
In case you missed my reply, I posted the sort table on 9/15/2007 to your attention. I didn't miss it, but I am still analyzing it to try to find a consistent set of parsing rules. Sorry, I should have posted a reply to that effect so you would know I was working on it when I get a little spare time. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Attn: Marshall Barton
Marsh,
No problem...thanks for the update!. Tom On Thu, 20 Sep 2007 11:36:49 -0500, Marshall Barton wrote: Tom wrote: In case you missed my reply, I posted the sort table on 9/15/2007 to your attention. I didn't miss it, but I am still analyzing it to try to find a consistent set of parsing rules. Sorry, I should have posted a reply to that effect so you would know I was working on it when I get a little spare time. -- Tom |
#4
|
|||
|
|||
Attn: Marshall Barton
On Thu, 20 Sep 2007 09:18:03 -0400, Tom wrote:
Marsh, In case you missed my reply, I posted the sort table on 9/15/2007 to your attention. Thx for your help. Tom Is the sort table you posted, sorted the way you want after a sort? Chuck |
#5
|
|||
|
|||
Attn: Marshall Barton
No, it was not in the correct order. It was in groups or patterns of
numbers. On Fri, 21 Sep 2007 06:06:52 -0400, Chuck wrote: On Thu, 20 Sep 2007 09:18:03 -0400, Tom wrote: Marsh, In case you missed my reply, I posted the sort table on 9/15/2007 to your attention. Thx for your help. Tom Is the sort table you posted, sorted the way you want after a sort? Chuck -- Tom |
#6
|
|||
|
|||
Attn: Marshall Barton
On Fri, 21 Sep 2007 18:54:00 -0400, Tom wrote:
No, it was not in the correct order. It was in groups or patterns of numbers. On Fri, 21 Sep 2007 06:06:52 -0400, Chuck wrote: On Thu, 20 Sep 2007 09:18:03 -0400, Tom wrote: Marsh, In case you missed my reply, I posted the sort table on 9/15/2007 to your attention. Thx for your help. Tom Is the sort table you posted, sorted the way you want after a sort? Chuck Are some of the wildly different part numbers, interchangeable parts? If yes, there is no way to sort them in any useful manner with the data you have shown us show. Are the part numbers from different organizations? If yes, there is no way to sort them in any useful manner with the data you have shown us show. In your post of 7/2/2007, you said you had an unbreakable UDF. Is it still unbreakable? If no, why not? Chuck |
#7
|
|||
|
|||
Attn: Marshall Barton
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 On Sat, 22 Sep 2007 08:28:25 -0400, Chuck wrote: On Fri, 21 Sep 2007 18:54:00 -0400, Tom wrote: No, it was not in the correct order. It was in groups or patterns of numbers. On Fri, 21 Sep 2007 06:06:52 -0400, Chuck wrote: On Thu, 20 Sep 2007 09:18:03 -0400, Tom wrote: Marsh, In case you missed my reply, I posted the sort table on 9/15/2007 to your attention. Thx for your help. Tom Is the sort table you posted, sorted the way you want after a sort? Chuck Are some of the wildly different part numbers, interchangeable parts? If yes, there is no way to sort them in any useful manner with the data you have shown us show. Are the part numbers from different organizations? If yes, there is no way to sort them in any useful manner with the data you have shown us show. In your post of 7/2/2007, you said you had an unbreakable UDF. Is it still unbreakable? If no, why not? Chuck -- Tom |
#8
|
|||
|
|||
Attn: Marshall Barton
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 -- |
#9
|
|||
|
|||
Attn: Marshall Barton
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 -- Tom |
#10
|
|||
|
|||
Attn: Marshall Barton
On Mon, 24 Sep 2007 18:15:41 -0400, Tom wrote:
Chuck, Here that file with everything sorted. Thanks Big Snip OK, I'll play with it and let you know if I have any luck. Chuck -- |
Thread Tools | |
Display Modes | |
|
|