I have a large number of files, each of which follows a similar format. In each one there is a section I want to focus on which looks like this
Company Name Acme Inc
2011 Growth Rate:
Essentially I want to parse only the sales figures (and accompanying headings) from this text file into a csv file, so it would look like below
Company Name 2011 Sales 2010 Sales 2011 Growth Rate
Acme Inc 3,000 2,000 50.00%
Ideally I would love to have a single piece of code to run through the many similar text files and create a single csv file of all this sales data but since I'm completely new to Perl, probably wiser to try get the first file done first! I imagine Perl is the best tool for this task but I'm at a loss how to start so any guidance would be most appreciated!