I'm still waiting for that perl script!
Should I really do all the work alone (except bathing in money and key caps for sure)?
Can please someone write a perl (or whatever) script to do the following:
read a file with lines of the form:
user,302202,1
user,300549,12
Where user is any user name from this forum, 12345678 a part number and 1 the quantity.
The script should look up the part number in the stock list:
210939 DCS X1X RELEG. BASE - ROW 1 - BLACK (NN) ABS 70
212790 DCS X1X RELEG. BASE ROW 1 - BLUE/GRAY (GSM) ABS 25
211475 DCS X1X RELEG. BASE ROW 1 - MEDIUM GRAY (GG) ABS 4,500
302184 DCS X1X RELEG. BASE ROW 1 - YELLOW (YCA) ABS 300
212822 DCS X1X RELEG. BASE ROW 2 - BLUE (BR) ABS 70
211443 DCS X1X RELEG. BASE ROW 2 - BRIGHT WHITE (WA) ABS 215
300632 DCS X1X RELEG. BASE ROW 2 - DARK GRAY (GC) ABS 187
212823 DCS X1X RELEG. BASE ROW 2 - YELLOW (YK) ABS 165
210880 DCS X1X RELEG. BASE ROW 3 - GRAY (GJV) ABS 1,590
302291 DCS X1X ROW. 3 RELEG. BASE - WHITE (WFK) ABS 500
211524 DCS X1X ROW 1 - BEIGE (GAL) ABS 485
212035 DCS X1X ROW 1 - BLACK (NN) ABS 627
212286 DCS X1X ROW 1 - BLUE (BBM) ABS 1,018
300407 DCS X1X ROW 1 - BLUE (BET) ABS 150
301433 DCS X1X ROW 1 - BLUE (BFJ) ABS 240
300593 DCS X1X ROW 1 - BLUE (BFO) ABS 507
212036 DCS X1X ROW 1 - BRIGHT WHITE (WA) ABS 350
300674 DCS X1X ROW 1 - BROWN (TGH) ABS 820
210006 DCS X1X ROW 1 - DARK BEIGE (GAW) ABS 570
300408 DCS X1X ROW 1 - GREEN (VCK) ABS 289
210005 DCS X1X ROW 1 - LIGHT GRAY (GA) ABS 1,093
210019 DCS X1X ROW 1 - LIGHT GRAY (GGT) ABS 675
300090 DCS X1X ROW 1 - LIGHT GRAY (GTL) ABS 234
301190 DCS X1X ROW 1 - MEDIUM GRAY (GG) ABS 445
300594 DCS X1X ROW 1 - ORANGE (OBC) ABS 443
302089 DCS X1X ROW 1 - RELEG. BASE - GRAY (GX) ABS 31
301929 DCS X1X ROW 1 - RELEGENDABLE BASE - YELLOW (YK) ABS 15
301051 DCS X1X ROW 1 - WHITE (WFK) ABS 53
211312 DCS X1X ROW 1 - YELLOW (YY) ABS 197
210888 DCS X1X ROW 2 - BLACK (NN) ABS 50
300821 DCS X1X ROW 2 - BRIGHT WHITE (WA) ABS 775
212645 DCS X1X ROW 2 - DARK GRAY (GB) ABS 1,735
210025 DCS X1X ROW 2 - LIGHT GRAY (GA) ABS 484
212129 DCS X1X ROW 2 - MEDIUM GRAY (GG) ABS 300
212423 DCS X1X ROW 2 - RED (RR) ABS 150
210889 DCS X1X ROW 3 - BLACK (NN) ABS 150
212038 DCS X1X ROW 3 - BRIGHT WHITE (WA) ABS 200
210048 DCS X1X ROW 3 - LIGHT GRAY (GA) ABS 268
211430 DCS X1X ROW 3 - MEDIUM GRAY (GG) ABS 70
211527 DCS X1X ROW 4 - BEIGE (GAL) ABS 533
212078 DCS X1X ROW 4 - BLACK (NN) ABS 1,636
210093 DCS X1X ROW 4 - DARK BEIGE (GAW) ABS 2,100
210096 DCS X1X ROW 4 - LIGHT GRAY (GA) ABS 40
300092 DCS X1X ROW 4 - LIGHT GRAY (GTL) ABS 339
300031 DCS X1.5X ROW 2 - BLACK (NN) ABS 15
300988 DCS X1.5X ROW 2 - BRIGHT WHITE (WA) ABS 396
301296 DCS X1.5X ROW 2 - CLEAR (UCJ) ABS 10
211648 DCS X1.5X ROW 2 - MEDIUM GRAY (GG) ABS 30
210805 DCS X1.5X ROW 3 - BRIGHT WHITE (WA) ABS 70
212594 DCS X2HX RELEG. BASE - LIGHT BEIGE (GER) ABS 100
300215 DCS X2HX RELEG. BASE - LIGHT GRAY (GA) ABS 250
301868 DCS X2HX RELEGENDABLE BASE - RED (RA) ABS 290
300402 DCS X2HX ROW 1 - GREEN (VCK) ABS 30
211876 DCS X2HX ROW 1 - RED (RR) ABS 25
300299 DCS X2HX ROW 1 - YELLOW (YY) ABS 60
301258 DCS X2HX ROW 2 - BRIGHT WHITE (WA) ABS 72
301378 DCS X2VX ROW 2 VERTICAL - GRAY (GTM) ABS 25
302142 DCS X2VX ROW 2 VERTICAL - YELLOW (YY) ABS 41
301379 DCS X2HX ROW 4 - GRAY (GTM) ABS 50
300154 DCS X6.75X SPACEBAR - LIGHT GRAY (GA) ABS 323
211035 DCS X6.75X SPACEBAR - WHITE (WV) ABS 33
300978 DCS X6X SPACE BAR (ROW 3) - BLACK (NN) ABS 25
302083 DCS X7X UNIT SPACE BAR - GRAY (GE) ABS 79
302007 DCS X7X UNIT SPACE BAR - WHITE (WFO) ABS 232
204754 DCS X7X SPACE BAR - BLACK (NN) ABS 161
210706 DCS X7X SPACEBAR - BEIGE (GAL) ABS 127
212826 DCS X7X SPACEBAR - GRAY (GBA) ABS 169
211439 DCS X7X SPACEBAR - LIGHT GRAY (GA) ABS 55
210185 DCS X7X SPACEBAR - LIGHT GRAY (GAY) ABS 34
210188 DCS X8X SPACE BAR - BLACK (NN) ABS 108
212205 DCS X8X SPACEBAR - BEIGE (GAL) ABS 242
301492 DCS X9X SPACEBAR - LIGHT BEIGE (GFD) ABS 12
301063 DCS X9X SPACEBAR - WHITE (WFK) ABS 39
211048 DCS X9X SPACEBAR - WHITE (WV) ABS 54
210227 DCS X1X ROW 1 - BEIGE (WAT) PBT 250
212585 DCS X1X ROW 1 - BEIGE (WCX) PBT 540
301609 DCS X1X ROW 1 - BLUE (BCF) PBT 119
300647 DCS X1X ROW 1 - BLUE (BDJ) PBT 417
212812 DCS X1X ROW 1 - BLUE (BFG) PBT 80
301656 DCS X1X ROW 1 - BLUE (BFW) PBT 160
301610 DCS X1X ROW 1 - BRIGHT GREEN (VCC) PBT 76
212808 DCS X1X ROW 1 - BRIGHT GREEN (VCG) PBT 765
210230 DCS X1X ROW 1 - CREAM (WAS) PBT 70
210492 DCS X1X ROW 1 - CREAM (WAS) PBT 112
212013 DCS X1X ROW 1 - CREAM (WBK) PBT 525
210226 DCS X1X ROW 1 - DARK BEIGE (GCH) PBT 336
301654 DCS X1X ROW 1 - GREEN (VCT) PBT 500
212586 DCS X1X ROW 1 - GREY (GDL) PBT 435
210676 DCS X1X ROW 1 - LIGHT GRAY (GAH) PBT 200
210694 DCS X1X ROW 1 - LIGHT GRAY (GDM) PBT 280
300168 DCS X1X ROW 1 - LIGHT GRAY (GRA) PBT 288
210225 DCS X1X ROW 1 - MEDIUM GRAY (GEC) PBT 70
212803 DCS X1X ROW 1 - MEDIUM GRAY (GHO) PBT 320
212811 DCS X1X ROW 1 - ORANGE (OAZ) PBT 345
212814 DCS X1X ROW 1 - PURPLE (RCM) PBT 810
301608 DCS X1X ROW 1 - RED (RCF) PBT 56
212809 DCS X1X ROW 1 - RED (RCK) PBT 1,110
301655 DCS X1X ROW 1 - WHITE (WFN) PBT 100
212476 DCS X1X ROW 1 - YELLOW (YAM) PBT 535
212810 DCS X1X ROW 1 - YELLOW (YBX) PBT 635
300576 DCS X1X ROW 1 HOMING BAR - BLUE (BFG) PBT 330
211080 DCS X1X ROW 1 HOMING BAR - MEDIUM GRAY (GEC) PBT 288
300171 DCS X1X ROW 1 HOMING BAR - PINK (RCL) PBT 213
300170 DCS X1X ROW 1 HOMING BAR - PURPLE (RCM) PBT 175
212195 DCS X1X ROW 1 HOMING BUMP - LIGHT GRAY (GDM) PBT 100
302011 DCS X1X ROW 2 - PINK (RCA) PBT 78
210233 DCS X1X ROW 2 - BEIGE (WAT) PBT 438
301985 DCS X1X ROW 2 - BEIGE (WCX) PBT 135
200035 DCS X1X ROW 2 - BLUE (BCT) PBT 150
300232 DCS X1X ROW 2 - BLUE (BDJ) PBT 1,380
301612 DCS X1X ROW 2 - BLUE (BFC) PBT 321
210236 DCS X1X ROW 2 - CREAM (WAS) PBT 100
212015 DCS X1X ROW 2 - CREAM (WBK) PBT 1,052
210232 DCS X1X ROW 2 - DARK BEIGE (GCH) PBT 1,535
302012 DCS X1X ROW 2 - GRAY (GKP) PBT 95
212728 DCS X1X ROW 2 - GREEN (VAZ) PBT 81
302009 DCS X1X ROW 2 - GREEN (VCR) PBT 128
212587 DCS X1X ROW 2 - GREY (GDL) PBT 236
210677 DCS X1X ROW 2 - LIGHT GRAY (GAH) PBT 218
212821 DCS X1X ROW 2 - LIGHT GRAY (GAH) PBT 275
210695 DCS X1X ROW 2 - LIGHT GRAY (GDM) PBT 1,105
301211 DCS X1X ROW 2 - LIGHT GRAY (GQJ) PBT 700
210231 DCS X1X ROW 2 - MEDIUM GRAY (GEC) PBT 150
212569 DCS X1X ROW 2 - MEDIUM GRAY (GHO) PBT 80
302010 DCS X1X ROW 2 - ORANGE (OAX) PBT 98
302013 DCS X1X ROW 2 - PURPLE (RCB) PBT 187
302008 DCS X1X ROW 2 - RED (RBR) PBT 142
301611 DCS X1X ROW 2 - RED (RCF) PBT 22
210235 DCS X1X ROW 2 - WHITE (WAN) PBT 1,685
211226 DCS X1X ROW 2 - YELLOW (YAM0 PBT 69
210240 DCS X1X ROW 3 - BEIGE (WAT) PBT 349
301986 DCS X1X ROW 3 - BEIGE (WCX) PBT 571
301615 DCS X1X ROW 3 - BLUE (BFC) PBT 84
210243 DCS X1X ROW 3 - CREAM (WAS) PBT 1,943
212017 DCS X1X ROW 3 - CREAM (WBK) PBT 385
201460 DCS X1X ROW 3 - GRAY (GJW) PBT 1,130
210696 DCS X1X ROW 3 - LIGHT GRAY (GDM) PBT 625
301614 DCS X1X ROW 3 - LIGHT GRAY (GRA) PBT 32
212591 DCS X1X ROW 3 - LIGHT GRAY (GRZ) PBT 1,100
210238 DCS X1X ROW 3 - MEDIUM GRAY (GEC) PBT 370
210237 DCS X1X ROW 3 - MEDIUM GRAY (GHO) PBT 30
301613 DCS X1X ROW 3 - YELLOW (YBW) PBT 92
301653 DCS X1X ROW 3 - YELLOW (YCJ) PBT 100
301624 DCS X1X ROW 3 HOMING BAR - BLUE (BFC) PBT 180
300646 DCS X1X ROW 3 HOMING BAR - BRIGHT WHITE (WFJ) PBT 136
212018 DCS X1X ROW 3 HOMING BAR - CREAM (WBK) PBT 730
301623 DCS X1X ROW 3 HOMING BAR - YELLOW (YBW) PBT 188
210246 DCS X1X ROW 4 - BEIGE (WAT) PBT 444
301987 DCS X1X ROW 4 - BEIGE (WCX) PBT 88
301616 DCS X1X ROW 4 - BLUE (BFC) PBT 127
301618 DCS X1X ROW 4 - BRIGHT GREEN (VCC) PBT 30
210249 DCS X1X ROW 4 - CREAM (WAS) PBT 400
212019 DCS X1X ROW 4 - CREAM (WBK) PBT 729
210245 DCS X1X ROW 4 - DARK BEIGE (GCH) PBT 400
212364 DCS X1X ROW 4 - GREY (GDL) PBT 144
210697 DCS X1X ROW 4 - LIGHT GRAY (GDM) PBT 2,060
301617 DCS X1X ROW 4 - LIGHT GRAY (GRA) PBT 69
210244 DCS X1X ROW 4 - MEDIUM GRAY (GEC) PBT 75
301369 DCS X1X ROW 4 - MEDIUM GRAY (GHO) PBT 40
301619 DCS X1X ROW 4 - YELLOW (YCC) PBT 102
212806 DCS X1.25X ROW 1 - MEDIUM GRAY (GHO) PBT 325
301973 DCS X1.25X ROW 4 - BLUE (BDJ) PBT 50
301988 DCS X1.25X ROW 4 - GREY (GDL) PBT 88
300152 DCS X1.25X ROW 4 - MEDIUM GRAY (GEC) PBT 140
212283 DCS X1.5X ROW 1 - MEDIUM GRAY (GEC) PBT 40
212805 DCS X1.5X ROW 1 - MEDIUM GRAY (GHO) PBT 160
301658 DCS X1.5X ROW 1 - RED (RCZ) PBT 25
301657 DCS X1.5X ROW 1 - YELLOW (YCJ) PBT 15
301989 DCS X1.5X ROW 2 - BEIGE (WCX) PBT 21
212366 DCS X1.5X ROW 2 - GREY (GDL) PBT 40
301370 DCS X1.5X ROW 2 - LIGHT GRAY (GAH) PBT 30
301214 DCS X1.5X ROW 2 - LIGHT GRAY (GQJ) PBT 46
301620 DCS X1.5X ROW 2 - LIGHT GRAY (GRA) PBT 81
210699 DCS X1.5X ROW 2 - MEDIUM GRAY (GEC) PBT 75
211533 DCS X1.5X ROW 2 - RED (RAR) PBT 255
301215 DCS X1.5X ROW 2 - RED (RBR) PBT 185
300546 DCS X1.5X ROW 2 - YELLOW (YBW) PBT 40
212589 DCS X1.5X ROW 4 - BEIGE (GDL) PBT 95
301980 DCS X1.5X ROW 4 - BLUE (BDJ) PBT 500
210698 DCS X1.5X ROW 4 - LIGHT GRAY (GDM) PBT 230
212185 DCS X1.5X ROW 4 - MEDIUM GRAY (GEC) PBT 120
300153 DCS X1.75X ROW 3 - MEDIUM GRAY (GEC) PBT 20
210702 DCS X1.75X ROW 4 - MEDIUM GRAY (GEC) PBT 80
301990 DCS X1.75SX STEPPED ROW 3 - GREY (GDL) PBT 39
212590 DCS X2.25X ROW 3 - GRAY (GDL) PBT 36
210703 DCS X2.25X ROW 3 - MEDIUM GRAY (GEC) PBT 80
212370 DCS X2.25X ROW 4 - GRAY (GDL) PBT 41
210704 DCS X2.25X ROW 4 - MEDIUM GRAY (GEC) PBT 35
212807 DCS X2.5X ROW 1 - MEDIUM GRAY (GHO) PBT 327
301993 DCS X2.75X ROW 4 - GRAY (GDL) PBT 38
212815 DCS X2HX ROW 1 - BLUE (BFG) PBT 40
211305 DCS X2HX ROW 1 - GRAY (GDL) PBT 42
210700 DCS X2HX ROW 1 - MEDIUM GRAY (GEC) PBT 50
212804 DCS X2HX ROW 1 - MEDIUM GRAY (GHO) PBT 175
301225 DCS X2HX ROW 1 - YELLOW (YAM) PBT 25
300037 DCS X2VX ROW 1 VERTICAL - DARK BEIGE (GCH) PBT 300
301992 DCS X2HX ROW 2 - WHITE (WCX) PBT 34
201459 DCS X2HX ROW 3 - CREAM (WAS) PBT 96
211532 DCS X2HX ROW 3 - GREEN (VAZ) PBT 527
201458 DCS X2HX ROW 3 - RED (RAA) PBT 250
300645 DCS X2HX ROW 4 - BRIGHT WHITE (WFJ) PBT 259
211258 DCS X2HX ROW 4 - LIGHT GRAY (GDM) PBT 80
301991 DCS X2HX ROW 4 - WHITE (WCX) PBT 21
212817 DCS X2VX ROW 4 VERTICAL - BLUE (BFG) PBT 60
211307 DCS X2VX VERTICAL - ROW 4 - GRAY (GDL) PBT 37
302185 DCS X1X RELEG. BASE - ROW 1 - CLEAR (UX) PC 920
210193 DCS X1X RELEG. TOP - ROW 1 PC 1,040
210881 DCS X1X RELEG. TOP - ROW 3 PC 290
200136 DCS X1X ROW 2 RELEG. TOP PC 850
300216 DCS X2HX RELEG. TOP PC 90
200258 DCS X2HX RELEG. TOP PC 7,090
300764 DSA X1X - BEIGE (GAL) ABS 390
210336 DSA X1X - BEIGE (GCF) - RECESSED MOUNT ABS 3,317
212705 DSA X1X - BLACK (NN) ABS 2,010
300294 DSA X1X - BLACK (NN) - RECESSED MOUNT ABS 250
300264 DSA X1X - BLUE (BE) ABS 118
212499 DSA X1X - BRIGHT WHITE (WA) ABS 3,530
300523 DSA X1X - DARK BLUE (BBI) - RECESSED MOUNT ABS 1,500
210624 DSA X1X - DARK GRAY (GB) ABS 553
302296 DSA X1X - GRAY (GTC) ABS 70
210330 DSA X1X - RED (RA) - RECESSED MOUNT ABS 1,980
300522 DSA X1X - WHITE (WFK) - RECESSED MOUNT ABS 4,792
212670 DSA X1X RELEG. BASE - BLACK (NN) - RECESSED MOUN ABS 1,840
212796 DSA X1X RELEG. BASE - BLUE/GRAY (GSM) ABS 555
212785 DSA X1X RELEG. BASE - BRIGHT WHITE (WA) - RECESS ABS 144
200348 DSA X1X RELEG. BASE - DARK GRAY (GB) ABS 2,135
212710 DSA X1X RELEG. BASE - DARK GRAY (GB) ABS 20,000
212494 DSA X1X RELEG. BASE - GLOW IN THE DARK ABS 3,250
301687 DSA X1X RELEG. BASE - LIGHT GRAY (GTB) ABS 75
211279 DSA X1.5X - BLACK (NN) ABS 64
212582 DSA X1.5X - GRAY (GG) ABS 25
204022 DSA X2HX - BRIGHT WHITE (WA) ABS 40
212120 DSA X2HX - RED (RA) ABS 1,150
204023 DSA X3X - BRIGHT WHITE (WA) ABS 160
301074 DSA X6X UNIT SPACE BAR - GRAY (GLY) ABS 37
301739 DSA X6X UNIT SPACE BAR - WHITE (WFO) ABS 77
301163 DSA X6X SPACEBAR - YELLOW (YY) ABS 74
300629 DSA X8X SPACEBAR - BEIGE (GAL) ABS 145
211988 DSA X8X SPACEBAR - BLACK (NN) ABS 328
300602 DSA X8X SPACEBAR - LIGHT GRAY (GA) ABS 3
211178 DSA X8X SPACEBAR - WHITE (WW) ABS 7
301960 DSA X0X RELEGENDABLE BASE - GREY (GTT) ABS 150
301928 DSA X0X RELEGENDABLE BASE - WHITE (WFO) ABS 150
210681 DSA X0X RELEGENDALE BASE - BLACK (NN) ABS 125
301733 DSA X1.5X - DARK BEIGE (GDL) PBT 295
301732 DSA X1.5X - WHITE (WCX) PBT 220
212269 DSA X1X - BEIGE (WBR) PBT 184
301961 DSA X1X - BLACK (NDY) PBT 134
212226 DSA X1X - BLUE (BDJ) PBT 320
301483 DSA X1X - BRIGHT GREEN (VCC) PBT 150
301925 DSA X1X - GRAY (GDM) PBT 35
212415 DSA X1X - LIGHT GRAY (GHO) PBT 189
301261 DSA X1X - NATURAL (UP) PBT 330
301481 DSA X1X - ORANGE (OAX) PBT 50
301479 DSA X1X - PINK (RCH) PBT 49
301480 DSA X1X - PURPLE (RCB) PBT 65
212254 DSA X1X - RED (RAR) PBT 60
301478 DSA X1X - TAN (TT) PBT 110
212225 DSA X1X - WHITE (WAN) PBT 320
301730 DSA X1X - WHITE (WCX) PBT 960
300804 DSA X1X - YELLOW (YAM) PBT 119
301844 DSA X1X W/ HOMING BUMP - WHITE (WCX) PBT 156
301800 DSA X1X WITH HOMING BUMP - WHITE (WCX) PBT 449
301842 DSA X2.25X - WHITE (WCX) PBT 19
301836 DSA X2HX - BEIGE (WBR) PBT 42
301736 DSA X2HX - DARK BEIGE (GDL) PBT 24
212709 DSA X1X - RELEG. TOP PC 59,365
300664 DSA X1X RELEG. BASE - CLEAR (UX) PC 350
210859 DSA X1X RELEG. TOP PC 5,839
200501 DSA X0X LIGHTED 1 1/2 SP - WEL PC 120
200502 DSA X0X LIGHTED 2 SP - WEL PC 20
300503 KT2000 X1X - BEIGE (GTF) ABS 2,305
300518 KT2000 X1X - BLACK (NN) ABS 740
300537 KT2000 X1X - BLUE (BFO)) ABS 1,000
300618 KT2000 X1X - BLUE (BFP) ABS 4,210
300784 KT2000 X1X - BRIGHT RED (RCQ) ABS 379
301824 KT2000 X1X - BROWN (TGH) ABS 730
300480 KT2000 X1X - DARK BEIGE (GAW) ABS 3,215
302198 KT2000 X1X - DARK GREY (GO) ABS 360
302098 KT2000 X1X - GREEN (VCK) ABS 1,400
301077 KT2000 X1X - GREEN (VCM) ABS 1,442
302199 KT2000 X1X - GREY (GSZ) ABS 1,600
301782 KT2000 X1X - PURPLE (RCJ) ABS 1,600
300481 KT2000 X1X - YELLOW (YCD) ABS 618
302097 KT2000 X1X - YELLOW (YY) ABS 1,347
301823 KT2000 X1X HOMING BAR - BEIGE (GTF) ABS 962
301380 KT2000 X1X HOMING BAR - BLACK (NN) ABS 255
300706 KT2000 X1X WHITE (WFK) ABS 650
300833 KT2000 X1.25X - BLACK (NN) ABS 285
300519 KT2000 X1.25X - BLUE (BFP) ABS 140
300938 KT2000 X1.25X - BRIGHT RED (RCQ) ABS 440
300704 KT2000 X1.25X - DARK BEIGE (GAW) ABS 345
302200 KT2000 X1.25X - DARK GREY (GO) ABS 25
301784 KT2000 X1.25X - PURPLE (RCJ) ABS 200
300798 KT2000 X1.5X - BEIGE (GTF) ABS 57
301205 KT2000 X1.5X - BLACK (NN) ABS 666
301008 KT2000 X1.5X - BLUE (BFP) ABS 180
301822 KT2000 X1.5X - DARK BEIGE (GAW) ABS 270
302201 KT2000 X1.5X - GRAY (GO) ABS 225
301855 KT2000 X1.5X - GREEN (VCM) ABS 85
300970 KT2000 X1.75SX STEPPED - BEIGE (GTF) ABS 118
302202 KT2000 X1.75SX STEPPED - GRAY (GO) ABS 25
300758 KT2000 X2HX HORIZONTAL - BEIGE (GTF) ABS 115
300482 KT2000 X2HX HORIZONTAL - BLACK (NN) ABS 290
302117 KT2000 X2HX HORIZONTAL - BLUE (BFP) ABS 42
301567 KT2000 X2HX HORIZONTAL - BRIGHT RED (RCQ) ABS 70
301078 KT2000 X2HX HORIZONTAL - DARK BEIGE (GAW) ABS 711
300797 KT2000 X2VX VERTICAL - BEIGE (GTF) ABS 643
301799 KT2000 X2VX VERTICAL - BLACK (NN) ABS 460
302204 KT2000 X2VX VERTICAL - GRAY (GO) ABS 365
302203 KT2000 X2VX VERTICAL - GRAY (GSZ) ABS 45
302100 KT2000 X2VX VERTICAL - GREEN (VCK) ABS 20
302095 KT2000 X2VX VERTICAL - RED (RCQ) ABS 20
302205 KT2000 X2.25X LEFT - GRAY (GO) ABS 25
300505 KT2000 X2.25X LEFT MOUNT - BEIGE (GTF) ABS 1,285
301783 KT2000 X2.25X LEFT MOUNT - PURPLE (RCJ) ABS 200
300530 KT2000 X2.25X RIGHT MOUNT - BEIGE (GTF) ABS 190
300529 KT2000 X2.25X RIGHT MOUNT - WHITE (WFK) ABS 24
300483 KT2000 X2.75X - BEIGE (GTF) ABS 281
302206 KT2000 X2.75X RIGHT - GRAY (GO) ABS 25
300527 KT2000 X1X - BEIGE (GTK) PBT 3,000
301343 KT2000 X1X - BEIGE (WAT) PBT 260
301046 KT2000 X1X - BLUE (BCT) PBT 1,285
301337 KT2000 X1X - BLUE (BDJ) PBT 140
301218 KT2000 X1X - BLUE (BFV) PBT 100
300939 KT2000 X1X - BROWN (TGJ) PBT 685
300974 KT2000 X1X - GRAY (GTP) PBT 309
300894 KT2000 X1X - GREEN (VCP) PBT 6,077
300972 KT2000 X1X - GREEN (VCR) PBT 850
301219 KT2000 X1X - ORANGE (OAX) PBT 150
301307 KT2000 X1X - ORANGE (OAY) PBT 210
301306 KT2000 X1X - PINK (RCA) PBT 335
300973 KT2000 X1X - RED (RBR) PBT 360
300895 KT2000 X1X - RED (RCP) PBT 510
301221 KT2000 X1X - YELLOW (YAM) PBT 23
300896 KT2000 X1X - YELLOW (YBV) PBT 790
301305 KT2000 X1X - YELLOW (YR) PBT 40
301338 KT2000 X1X HOMING BAR - YELLOW (YAM) PBT 75
301315 KT2000 X1X HOMING BAR - YELLOW (YR) PBT 35
301340 KT2000 X1.5X - PINK (RCA) PBT 16
302191 KT2000 X2HX HORIZONTAL - BLUE (BCT) PBT 80
302192 KT2000 X2VX VERTICAL - WHITE (WAN) PBT 70
300199 SA X1X - BLACK (NN) ABS 60
212618 SA X1X - DARK GREY (GC) ABS 268
212295 SA X1X - BROWN (TL) ABS 500
300193 SA X1X - LIGHT GRAY (GA) ABS 23
212003 SA X1X - ORANGE (OAS) ABS 50
210879 SA X1X - RED (RR) ABS 90
211501 SA X1X - TAN (TEA) ABS 100
212294 SA X1X - YELLOW/BROWN (YW) ABS 70
212506 SA X1X RELEG. BASE - DARK BLUE (BO) ABS 375
300874 SA X1X RELEG. BASE - LIGHT GRAY (GA) ABS 130
212617 SA X1.5X - DARK GRAY (GB) ABS 752
301835 SA X2HX - WHITE (WA) ABS 224
300639 SA X8X SPACEBAR - DARK GRAY (GB) ABS 50
212480 SA X8X SPACEBAR - DARK GRAY (GX) ABS 11
301754 SA X1X - CREAM (WAS) PBT 160
212646 SA X1X - WHITE (WAN) PBT 200
301087 SA X1X - WHITE (WBO) PBT 235
300552 SA X1.5X - BLUE (BDE) PBT 40
300549 SA X1.5X - ORANGE (OT) PBT 280
301642 SA X1X - TRANSLUCENT GREEN (VBZ) PC 81
212056 SA X1X RELEG. TOP PC 4,323
204890 SA X1X RELEG. TOP PC 5,880
And find the stuff between those to X-s:
300549 SA X1.5X - ORANGE (OT) PBT 280
302202 KT2000 X1.75SX STEPPED - GRAY (GO) ABS 25
300758 KT2000 X2HX HORIZONTAL - BEIGE (GTF) ABS 115
looking up 302202 should give "1.75S" which needs to be translated to
"BLANKUNIT175S"
"1.5" -> "BLANKUNIT150"
"2H" -> "BLANKUNIT200H"
The script should spit out 2 files with the following lines:
(above example continued)
user,BLANKUNIT175S,1
the 2nd output (can go to stout) should be:
user,302202 KT2000 X1.75SX STEPPED - GRAY (GO) ABS 25
or better
user,302202 KT2000 1.75S STEPPED - GRAY (GO) ABS 25
Allright?
Any questions?
Well, then ...