L
Legacy 103420
Guest
hi. a project im working on requires us to match items with their parts. the problem is we have a really big list of parts and some duplicates. we tried to highlight all duplicate values and then sort by cell color, but this takes a so long time! then when it is done we have to remove the duplicate values because exists duplicates which cause the rows to not lineup.
example below of original file:
<style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small } --> </style>
<colgroup><col width="86"><col width="86"><col width="86"></colgroup> <tbody>
[TD="width: 86"] Items w/o parts [/TD]
[TD="width: 86"] Items [/TD]
[TD="width: 86"] Parts [/TD]
</tbody>
after sorting:
<style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small } --> </style>
<colgroup><col width="86"><col width="86"><col width="86"></colgroup> <tbody>
[TD="width: 86"] Items w/o parts
[/TD]
[TD="width: 86"] Items [/TD]
[TD="width: 86"] Parts [/TD]
</tbody>
the problem is <style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small } --> </style>
<colgroup><col width="86"><col width="86"></colgroup> <tbody>
[TD="width: 86"] 143_ABC [/TD]
[TD="width: 86"] BL21 [/TD]
</tbody><style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small } --> </style>
<colgroup><col width="86"><col width="86"></colgroup> <tbody>
[TD="width: 86"] 143_ABC [/TD]
[TD="width: 86"] BL21 [/TD]
</tbody>
if we remove this as duplicate it is deleted altogether. the solution manually is to delete bottom one and merge cell and rows to the right of it up one. then all the lines are aligned properly and the lost items matched with parts. but as you see this is quite a complex problem. plus we have over 10k lines into it. sorting takes so long time... some way to better do this?
thnx in advanced.
example below of original file:
<style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small } --> </style>
149_ABC | 123_ABC | BL1 |
132_ABC | 124_ABC | BL2 |
142_ABC | 125_ABC | BL3 |
124_ABC | 126_ABC | BL4 |
130_ABC | 127_ABC | BL5 |
134_ABC | 128_ABC | BL6 |
137_ABC | 129_ABC | BL7 |
140_ABC | 130_ABC | BL8 |
143_ABC | 131_ABC | BL9 |
139_ABC | 132_ABC | BL10 |
128_ABC | 132_ABC | BL10 |
133_ABC | 133_ABC | BL11 |
145_ABC | 134_ABC | BL12 |
136_ABC | 135_ABC | BL13 |
136_ABC | BL14 | |
137_ABC | BL15 | |
138_ABC | BL16 | |
139_ABC | BL17 | |
140_ABC | BL18 | |
141_ABC | BL19 | |
142_ABC | BL20 | |
143_ABC | BL21 | |
143_ABC | BL21 | |
144_ABC | BL22 | |
145_ABC | BL23 | |
146_ABC | BL24 | |
147_ABC | BL25 | |
148_ABC | BL26 | |
149_ABC | BL27 |
<colgroup><col width="86"><col width="86"><col width="86"></colgroup> <tbody>
[TD="width: 86"] Items w/o parts [/TD]
[TD="width: 86"] Items [/TD]
[TD="width: 86"] Parts [/TD]
</tbody>
after sorting:
<style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small } --> </style>
124_ABC | 124_ABC | BL2 |
128_ABC | 128_ABC | BL6 |
130_ABC | 130_ABC | BL8 |
132_ABC | 132_ABC | BL10 |
133_ABC | 133_ABC | BL11 |
134_ABC | 134_ABC | BL12 |
136_ABC | 136_ABC | BL14 |
137_ABC | 137_ABC | BL15 |
139_ABC | 139_ABC | BL17 |
140_ABC | 140_ABC | BL18 |
142_ABC | 142_ABC | BL20 |
143_ABC | 143_ABC | BL21 |
145_ABC | 143_ABC | BL21 |
149_ABC | 145_ABC | BL23 |
149_ABC | BL27 | |
123_ABC | BL1 | |
125_ABC | BL3 | |
126_ABC | BL4 | |
127_ABC | BL5 | |
129_ABC | BL7 | |
131_ABC | BL9 | |
132_ABC | BL10 | |
135_ABC | BL13 | |
138_ABC | BL16 | |
141_ABC | BL19 | |
144_ABC | BL22 | |
146_ABC | BL24 | |
147_ABC | BL25 | |
148_ABC | BL26 |
<colgroup><col width="86"><col width="86"><col width="86"></colgroup> <tbody>
[TD="width: 86"] Items w/o parts
[/TD]
[TD="width: 86"] Items [/TD]
[TD="width: 86"] Parts [/TD]
</tbody>
the problem is <style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small } --> </style>
<colgroup><col width="86"><col width="86"></colgroup> <tbody>
[TD="width: 86"] 143_ABC [/TD]
[TD="width: 86"] BL21 [/TD]
</tbody>
<colgroup><col width="86"><col width="86"></colgroup> <tbody>
[TD="width: 86"] 143_ABC [/TD]
[TD="width: 86"] BL21 [/TD]
</tbody>
if we remove this as duplicate it is deleted altogether. the solution manually is to delete bottom one and merge cell and rows to the right of it up one. then all the lines are aligned properly and the lost items matched with parts. but as you see this is quite a complex problem. plus we have over 10k lines into it. sorting takes so long time... some way to better do this?
thnx in advanced.