I wrote this code to read an excel csv file with five records per line. However, the
<tr> shows up at the beginning of the output file and the
</tr> shows up at the end. I want to get them to show up at the beginning and end of each line.
Is the probem with my CSV or my code. I can't see straight anymore :(
use CGI qw(:standard);
use strict;
use warnings;
my $line;
my $file;
my ($f1,$f2,$f3,$f4,$f5);
my $output = "new.htm";
open (OUTPUT, ">$output") or die "Cannot open $output";
my $z=0;
$file='irregular-verbs.csv';
open(F,$file)||die("Could not open $file");
while ($line=<F>)
{
print OUTPUT "<tr>";
my @cells= split ',',$line;
foreach my $cell (@cells)
{
print OUTPUT "<td>$cell</td>";
}
print OUTPUT "</tr>";
}
close(F);
First few lines of the OUTPUT file.
<tr><td>Base Form</td><td>Past Simple</td><td>Past Participle</td><td>
+3rd Person Singular</td><td>Present Participle / Gerund
Abide</td><td>Abode/Abided</td><td>Abode/Abided/Abidden</td><td>Abides
+</td><td>Abiding
Aby/Abye</td><td>Abought</td><td>Abought</td><td>Abys/Abyes</td><td>Ab
+ying
Alight</td><td>Alit/Alighted</td><td>Alit/Alighted</td><td>Alights</td
+><td>Alighting
Arise</td><td>Arose</td><td>Arisen</td><td>Arises</td><td>Arising
Awake</td><td>Awoke</td><td>Awoken</td><td>Awakes</td><td>Awaking
Thanks for your help!
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: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.