i can try the Text::CSV module too....

The Text::CSV module provides functions for both parsing and producing CSV data. However, we'll focus on the parsing functionality here. The following code sample opens the prospects.csv file and parses each line in turn, printing out all the fields it finds.

    #!/usr/bin/perl
    use strict;
    use warnings;
    use Text::CSV;

    my $file = 'prospects.csv';

    my $csv = Text::CSV->new();

    open (CSV, "<", $file) or die $!;

    while (<CSV>) {
        if ($csv->parse($_)) {
            my @columns = $csv->fields();
            print "@columns\n";
        } else {
            my $err = $csv->error_input;
            print "Failed to parse line: $err";
        }
    }
    close CSV;
[download]

Running the code produces the following output:

    Name Address Floors Donated last year Contact
    Charlotte French Cakes 1179 Glenhuntly Rd 1 Y John
    Glenhuntly Pharmacy 1181 Glenhuntly Rd 1 Y Paul
    Dick Wicks Magnetic Pain Relief 1183-1185 Glenhuntly Rd 1 Y George
    Gilmour's Shoes 1187 Glenhuntly Rd 1 Y Ringo
[download]

And by replacing the line:

          print "@columns\n";
[download]

with:

            print "Name: $columns[0]\n\tContact: $columns[4]\n";
[download]

we can get more particular about which fields we want to output. And while we're at it, let's skip past the first line of our csv file, since it's only a list of column names.

  #!/usr/bin/perl
    use strict;
    use warnings;
    use Text::CSV;

    my $file = 'prospects.csv';

    my $csv = Text::CSV->new();

    open (CSV, "<", $file) or die $!;

    while (<CSV>) {
        next if ($. == 1);
        if ($csv->parse($_)) {
            my @columns = $csv->fields();
            print "Name: $columns[0]\n\tContact: $columns[4]\n";
        } else {
            my $err = $csv->error_input;
            print "Failed to parse line: $err";
        }
    }
    close CSV;
[download]

Running this code will give us the following output:

    Name: Charlotte French Cakes
            Contact: John
    Name: Glenhuntly Pharmacy
            Contact: Paul
    Name: Dick Wicks Magnetic Pain Relief
            Contact: George<br>

    Name: Gilmour's Shoes
            Contact: Ringo
[download]

well i can get some analogies what do you think!

---

---

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! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

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:
	&		&
	<		&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.