Why limit your code to one match at a time? As long as you are capturing things, you can use 1 regex to extract all the details from a question at once. If your questions are separated by a blank line (i.e. end marked by "\n\n"), you could try something like:

#!/usr/bin/perl
use strict;
use warnings;

my $file = "data.txt";
open (INPUT, "< $file");
undef $/;
my $string = <INPUT>;
while ($string =~ /(\d+)\.\n(.+?)A\)(.+?)B\)(.+?)C\)(.+?)D\)(.+?)(\n\n
+|$)/sg) {
    my @captures = ($1, $2, $3, $4, $5, $6);
    foreach (@captures) {
        s/\n//g;
    }
    print "<QN>$captures[0]</QN>\n";
    print "<QQ>$captures[1]</QQ>\n";
    print "<Aa>$captures[2]</Aa>\n";
    print "<Ab>$captures[3]</Ab>\n";
    print "<Ac>$captures[4]</Ac>\n";
    print "<Ad>$captures[5]</Ad>\n";
}
close (INPUT);

[download]

Some side notes: you should use strict; use warnings in your scripts since they'll help prevent typos from causing you incredible misery. You should use 3-argument open in place of the 2-argument form you used - 3-argument has some important security implications.

In reply to Re^3: Multiple choice from text file to SQL by kennethk
in thread Multiple Line Data from text file to SQL by pie2re

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.