Hi everyone

I am new to Perl. I want to get the specific information from a txt file by Perl. The following is description of the text file and what I want to get.

#####################################

C2H4 H2O3 C160H33O (1)

1 2 5 (2)

C2H4 H2O3 O4 (3)

2 1 3 (4)

C452H576O4 C2H4 (5)

1 1 (6)

…

######################################

The content of txt file is listed above. The name of the txt file is species.txt. There are two kinds of lines. One of the lines (labeled as (1) (3) (5)) is the chemical species and another one (labeled as (2) (4) (6)) is the number of the corresponding chemical species. And the chemical species and the numbers are not vertical alignment. And the chemical species are different from line to line. I want to get the number of the chemical species and output it into an Excel spreadsheet. Take the C2H4 as an example, the output should like this: C2H4

1

2

1

How can I do that by Perl? Thanks for your help Fan Li

In reply to Extract the number of the species for txt file by fan li

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.