Beefy Boxes and Bandwidth Generously Provided by pair Networks vroom
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Output particular sections of txt file to csv?

by Anonymous Monk
on Apr 09, 2013 at 21:51 UTC ( #1027852=perlquestion: print w/ replies, xml ) Need Help??
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

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 Something: this Something else: that Something else: etc. Sales 2011 Sales: 3,000 () 2010 Sales: 2,000 () 2011 Growth Rate: 50.00% Contact Details

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!

Comment on Output particular sections of txt file to csv?
Select or Download Code
Re: Output particular sections of txt file to csv?
by choroba (Abbot) on Apr 09, 2013 at 22:24 UTC
    Crossposted at StackOverflow. It is considered polite to inform about crossposting, so that people not attending both sites do not waste their efforts on a problem already solved at the other end of the Internet.
    لսႽ ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ
Re: Output particular sections of txt file to csv?
by Anonymous Monk on Apr 10, 2013 at 02:08 UTC

    Hi,

    A fewe pointers

    Search the web / this site for 'perl file handling', 'perl regex', 'perl csv', 'perl books' and 'perl tutorials'.

    That should get you started.

    Once you have written some code come back and let us give you more meaningful help.

    J.C.

Re: Output particular sections of txt file to CSV
by Tux (Monsignor) on Apr 10, 2013 at 07:56 UTC

    And your output is not CSV at all. It looks like either plain text or maybe TSV (Tab-Separated-Values).

    Either show what is actually required or be more specific and correct in the example of the output.

    Other than that, could you show the code of what you tried so far?


    Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1027852]
Approved by LanX
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (7)
As of 2014-04-21 06:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (492 votes), past polls