#!/usr/bin/perl
# filename: csv.pl
use strict;
use warnings;
foreach(<>){
my ($names, $address, $rest) = split '"';
my ($lastname, $firstname, $waste, $city, $state, $zip)
= (split (/,/ , $names), split(/,/ , $rest));
print join( "\n",
($lastname, $firstname, $address, $city, $state, $zip)),
"\n";
}
$ ./csv.pl < data.txt
Lastname
Firstname
Address, Apt/Suite #123
City
State
Zipcode
On 6/29/07, ankIT WALiA <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I want to retrive data from csv file.
> let us say record
> Lastname,Firstname,"Address, Apt/Suite #123",City,State,Zipcode
> when i split it using comma,
> it seprate out into
>
> Lastname
> Firstname
> Address
> Apt/Suite #123
> City
> State
> Zipcode
>
> but i need to store data into
>
> Lastname
> Firstname
> Address, Apt/Suite #123
> City
> State
> Zipcode
>
> I am using
> var oFile = Clib.fopen(vFilepath,"r");
> var string = (Clib.fgets(oFile));
> if(string)
> {
> var arr = string.split(",");
> }
>
> Please suggest something......
>
> Thanks
> --
> LIfe is like a Rose is upto u spreading its fragnance or thorns.
> अन्कित वालिया
> _______________________________________________
> ilugd mailinglist -- [email protected]
> http://frodo.hserus.net/mailman/listinfo/ilugd
> Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi
> http://www.mail-archive.com/[email protected]/
>
--
o1p2e3n4g5l6
http://saleem.a.ansari.googlepages.com/
http://www.jmilug.org/
http://www.csijmi.com/
Linux User #414799 (http://counter.li.org/)
_______________________________________________
ilugd mailinglist -- [email protected]
http://frodo.hserus.net/mailman/listinfo/ilugd
Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi
http://www.mail-archive.com/[email protected]/
