I tried the my @fields and I did not get it to work, probably because my
coding skills have not improved enough lately to be worthy of perl.
Thank goodness I never said I had perfect code, because I would
definitely be lying.
I attached 2 files, one the beginning data, the other the .sql file that
I load into MySQL database. The files are about 3000 lines before and
after so I cut out the first 30 lines and put them in the files to the
list.
What I need to figure out is how to make a sub call that when I pull in
the file will remove all extraneous white space. Something I can copy
into another Perl program to parse another set of files (ARGH!). I've
learned not to tell the bosses I can write a script to handle the errors
of the salesmen. I currently use a back piece of PHP coding to handle
the extra spaces in the pages that use the data, but for another project
I can't use that work-around.
I know I can do something along the lines of:
(from an HTML generating page with a sort)
foreach $i (sort ByName @grok)
{
chomp($i);
($type,$description,$parts,$numb) = split(/\|/,$i);
print <<INFO2;
<tr><td>$type</td><td>$description</td><td>$parts</td><td>$numb</td></tr
>
INFO2
}
The sub program:
sub ByName {
@a = split(/\|/,$a);
@b = split(/\|/,$b);
$a[1] cmp $b[1];
}
But I am still not sure how to make the $i go through, and it is
probably something simple I am missing.
Thanks!!
Robert
1|AA-1202|12in. X10.75 FOIL SHEETS
12/200|70.96|46.40|45.24|44.13|246|3|55.000|.000|.000|A|AA-1202
2|AA-1205|12in. x10in. FOIL POPUP SHEETS
6/500|96.61|63.17|61.59|60.09|246|3|19.000|.000|.000|B|AA-1205
3|AA-1215RO|12in. X1000ft. ROYALE FOIL STD
1|25.16|15.84|15.46|15.09|245|3|56.000|5.000|.000|B|AA-1215RO
4|AA-1217SE|12in. X1000 ALUMINUM FOIL STD
1|30.18|19.73|19.24|18.77|245|3|36.000|.000|.000|B|AA-1217SE
5|AA-1251|12in. X500 ALUMINUM FOIL (HVY)
EA|26.25|17.17|16.74|16.33|245|3|34.000|.000|.000|B|AA-1251
6|AA-1255RO|12in. X500ft. ROYALE FOIL STD
1/CS|15.96|10.05|9.81|9.58|245|3|30.000|.000|.000|C|AA-1255RO
7|AA-1817SE|18in. X1000 STD.DUTY FOIL-RL
1|42.82|28.00|27.30|26.63|245|3|17.000|.000|.000|C|AA-1817SE
8|AA-1825|18in. X25ft. HEAVY DUTY-RL
12|28.29|27.27|26.79|26.17|245|3|6.000|.000|.000|C|AA-1825
9|AA-1851SE|18in. X500 ALUMINUM FOIL (HVY)
1|32.67|21.36|20.83|20.32|245|3|116.000|4.000|.000|A|AA-1851SE
10|AA-1857SE|18in. X500in. ALUMINUM FOIL STD
1|24.41|15.96|15.56|15.18|245|3|67.000|.000|.000|B|AA-1857SE
11|AA-455-44|1/2 AL.STEAM T/PAN-MEDIUM
100|40.59|27.24|26.54|25.88|212|3|22.000|.000|.000|B|AA-455-44
12|AA-456-44|1/2 AL.STEAM T/PAN-DEEP
100|34.16|24.54|23.86|23.38|212|3|97.000|1.000|.000|A|AA-456-44
13|AA-457-70|FULL AL.STEAM T/PAN-MEDIUM
50|53.57|36.92|35.95|35.03|212|3|9.000|.000|.000|B|AA-457-70
14|AA-458-40|1/2 AL.STEAM T/PAN-SHALLOW
100|34.49|22.99|22.41|21.85|212|3|11.000|.000|.000|C|AA-458-40
15|AA-459-70|FULL AL.STEAM T/PAN-SHALLOW
50|53.02|36.30|35.35|34.45|212|3|8.000|1.000|.000|C|AA-459-70
16|AA-460-70|FULL AL.STEAM T/PAN-DEEP
50|44.49|30.25|29.47|28.72|212|3|116.000|2.000|.000|A|AA-460-70
17|AA-516430WLR|***9ft. RND CONT W/FOIL BD LD
250|57.80|49.13|45.35|42.11|77|3|8.000|.000|.000|D|AA-516430WLR
18|AA-552-40|ASHTRAY ROUND SILVER
1000|77.65|50.77|49.50|48.29|2|3|15.000|.000|.000|B|AA-552-40
19|AA-554-40|FULL AL.STEAM T/PAN-FOIL
COV50|27.45|17.95|17.50|17.07|212|3|42.000|2.000|.000|A|AA-554-40
20|AA-555-30|1/2 AL.STEAM T/PAN-FOIL
COV100|14.44|13.75|13.42|12.94|212|3|23.000|1.000|.000|B|AA-555-30
21|AA-688-64A|19in.
AL.ROAST.PAN-OVAL-GIANTG50|51.24|51.24|51.24|51.24|212|3|15.000|.000|.000|C|AA-688-64A
22|AA-9102|9X10.75 FOIL SHEETS
12/200|51.71|33.81|32.96|32.16|246|3|17.000|.000|.000|B|AA-9102
23|AA-9105|9X10.75 FOIL SHEETS
6/500|59.47|38.88|37.91|36.99|246|3|94.000|5.000|.000|A|AA-9105
24|AA-A12DL|12in. DOME CLEAR LID-A13&A16
25|13.73|9.72|9.46|9.21|41|3|3.000|.000|.000|C|AA-A12DL
25|AA-A12FT|12in. ALUMINUM FLAT TRAY
25|15.51|10.99|10.69|10.41|41|3|5.000|.000|.000|C|AA-A12FT
26|AA-A12LS|12in. ALUMINUM 5-CMPT.TRAY
25|15.51|10.99|10.69|10.41|41|3|15.000|.000|.000|C|AA-A12LS
27|AA-A16DL|16in. DOME CLEAR LID
25|20.76|14.71|14.31|13.93|41|3|11.000|1.000|.000|B|AA-A16DL
28|AA-A16FT|16in. ALUMINUM FLAT TRAY
25|25.69|18.19|17.70|17.24|41|3|10.000|1.000|.000|B|AA-A16FT
29|AA-A16LS|16in. ALUMINUM 5-CMPT.TRAY
25|25.69|18.19|17.70|17.24|41|3|8.000|.000|.000|C|AA-A16LS
30|AA-A18DL|18in. DOME CLEAR LID
25|29.84|21.14|20.57|20.03|41|3|7.000|1.000|.000|C|AA-A18DL
AA-1202 |12"X10.75 FOIL SHEETS 12/200| 70.96 | 46.40 | 45.24 |
44.13 |UF|ALCAN | 55.000 | .000 | .000 |A
AA-1205 |12"x10"FOIL POPUP SHEETS 6/500| 96.61 | 63.17 |
61.59 | 60.09 |UF|ALCAN | 19.000 | .000 | .000 |B
AA-1215RO |12"X1000' ROYALE FOIL STD 1| 25.16 | 15.84 |
15.46 | 15.09 |U5|ALCAN | 56.000 | 5.000 | .000 |B
AA-1217SE |12"X1000 ALUMINUM FOIL STD 1| 30.18 | 19.73 |
19.24 | 18.77 |U5|ALCAN | 36.000 | .000 | .000 |B
AA-1251 |12"X500 ALUMINUM FOIL (HVY) EA| 26.25 | 17.17 |
16.74 | 16.33 |U5|ALCAN | 34.000 | .000 | .000 |B
AA-1255RO |12"X500'ROYALE FOIL STD 1/CS| 15.96 | 10.05 |
9.81 | 9.58 |U5|ALCAN | 30.000 | .000 | .000 |C
AA-1817SE |18"X1000 STD.DUTY FOIL-RL 1| 42.82 | 28.00 |
27.30 | 26.63 |U5|ALCAN | 17.000 | .000 | .000 |C
AA-1825 |18"X25' HEAVY DUTY-RL 12| 28.29 | 27.27 |
26.79 | 26.17 |U5|ALCAN | 6.000 | .000 | .000 |C
AA-1851SE |18"X500 ALUMINUM FOIL (HVY) 1| 32.67 | 21.36 |
20.83 | 20.32 |U5|ALCAN | 116.000 | 4.000 | .000 |A
AA-1857SE |18"X500" ALUMINUM FOIL STD 1| 24.41 | 15.96 |
15.56 | 15.18 |U5|ALCAN | 67.000 | .000 | .000 |B
AA-455-44 |1/2 AL.STEAM T/PAN-MEDIUM 100| 40.59 | 27.24 |
26.54 | 25.88 |O7|ALCAN | 22.000 | .000 | .000 |B
AA-456-44 |1/2 AL.STEAM T/PAN-DEEP 100| 34.16 | 24.54 |
23.86 | 23.38 |O7|ALCAN | 97.000 | 1.000 | .000 |A
AA-457-70 |FULL AL.STEAM T/PAN-MEDIUM 50| 53.57 | 36.92 |
35.95 | 35.03 |O7|ALCAN | 9.000 | .000 | .000 |B
AA-458-40 |1/2 AL.STEAM T/PAN-SHALLOW 100| 34.49 | 22.99 |
22.41 | 21.85 |O7|ALCAN | 11.000 | .000 | .000 |C
AA-459-70 |FULL AL.STEAM T/PAN-SHALLOW 50| 53.02 | 36.30 |
35.35 | 34.45 |O7|ALCAN | 8.000 | 1.000 | .000 |C
AA-460-70 |FULL AL.STEAM T/PAN-DEEP 50| 44.49 | 30.25 |
29.47 | 28.72 |O7|ALCAN | 116.000 | 2.000 | .000 |A
AA-516430WLR|***9'RND CONT W/FOIL BD LD 250| 57.80 | 49.13 |
45.35 | 42.11 |6H|ALCAN | 8.000 | .000 | .000 |D
AA-552-40 |ASHTRAY ROUND SILVER 1000| 77.65 | 50.77 |
49.50 | 48.29 |08|ALCAN | 15.000 | .000 | .000 |B
AA-554-40 |FULL AL.STEAM T/PAN-FOIL COV50| 27.45 | 17.95 |
17.50 | 17.07 |O7|ALCAN | 42.000 | 2.000 | .000 |A
AA-555-30 |1/2 AL.STEAM T/PAN-FOIL COV100| 14.44 | 13.75 |
13.42 | 12.94 |O7|ALCAN | 23.000 | 1.000 | .000 |B
AA-688-64A |19" AL.ROAST.PAN-OVAL-GIANTG50| 51.24 | 51.24 |
51.24 | 51.24 |O7|ALCAN | 15.000 | .000 | .000 |C
AA-9102 |9X10.75 FOIL SHEETS 12/200| 51.71 | 33.81 |
32.96 | 32.16 |UF|ALCAN | 17.000 | .000 | .000 |B
AA-9105 |9X10.75 FOIL SHEETS 6/500| 59.47 | 38.88 |
37.91 | 36.99 |UF|ALCAN | 94.000 | 5.000 | .000 |A
AA-A12DL |12" DOME CLEAR LID-A13&A16 25| 13.73 | 9.72 |
9.46 | 9.21 |4J|ALCAN | 3.000 | .000 | .000 |C
AA-A12FT |12" ALUMINUM FLAT TRAY 25| 15.51 | 10.99 |
10.69 | 10.41 |4J|ALCAN | 5.000 | .000 | .000 |C
AA-A12LS |12" ALUMINUM 5-CMPT.TRAY 25| 15.51 | 10.99 |
10.69 | 10.41 |4J|ALCAN | 15.000 | .000 | .000 |C
AA-A16DL |16" DOME CLEAR LID 25| 20.76 | 14.71 |
14.31 | 13.93 |4J|ALCAN | 11.000 | 1.000 | .000 |B
AA-A16FT |16" ALUMINUM FLAT TRAY 25| 25.69 | 18.19 |
17.70 | 17.24 |4J|ALCAN | 10.000 | 1.000 | .000 |B
AA-A16LS |16" ALUMINUM 5-CMPT.TRAY 25| 25.69 | 18.19 |
17.70 | 17.24 |4J|ALCAN | 8.000 | .000 | .000 |C
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
