As a project I have to generate an excel file based on the output of a
text file.
I need to generate an excel file that is going to have a separate sheet
for each vendor. Then that sheet would be divided into 4 sections one
for each year. The excel part I can do. The problem is I can figure out
what data structure to build. It would need to contain the year, the
item code description sales and qty I thought I would name the
structures after the vendor. So all BAUE00 would be in one structure.
I am just learning how to build anything beyond an array of arrays or an
array of hashes.
I can complete this job without any help but I thought this would be a
good exercise on data structures. Any suggestions would be deeply
appreciated.
I am reading it like this to start.
while (<IN>){
chomp;
@temp = split /\|/,$_;
$_=~s/\s+$//g foreach (@temp);
Here is a sample of the source.
Source
------
Year item desc
vend sale qty unused
2001|000611 |Pylon 30" Sht Tit w/Angular adaptor|BAUE00
| 203.00 | 3.00 |ENDO
2002|000632 |Pyramid Adapter |BAUE00
| 314.00 | 6.00 |ENDO
2002|000650 |Sach Foot Adapter Titanium |BAUE00
| 155.00 | 3.00 |ENDO
2002|000656 |Tube Clamp Adaptor 30mm Titanium |BAUE00
| 1451.00 | 18.00 |ENDO
2002|008567 |AK Foam Cover Blank MD |BAUE00
| 75.00 | 1.00 |ENDO
2002|008568 |AK Foam Cover Blank XLG |BAUE00
| 1852.00 | 24.00 |ENDO
1999|008582 |Foam Block A/K F/Machine Medium |BAUE00
| 285.00 | 7.00 |ENDO
2000|008582 |Foam Block A/K F/Machine Medium |BAUE00
| 893.00 | 22.00 |ENDO
2001|008582 |Foam Block A/K F/Machine Medium |BAUE00
| 1750.00 | 45.00 |ENDO
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
