In case of any number of commas
On 6/29/07, Raj Mathur <[EMAIL PROTECTED]> wrote:
>
> On Friday 29 June 2007 15:57, ankIT WALiA wrote:
> > Hi all,
> > I want to retrive data from csv file.let us say
> > recordLastname,Firstname,"Address, Apt/Suite
> > #123",City,State,Zipcodewhen i split it using
On Friday 29 June 2007 15:57, ankIT WALiA wrote:
> Hi all,
> I want to retrive data from csv file.let us say
> recordLastname,Firstname,"Address, Apt/Suite
> #123",City,State,Zipcodewhen i split it using comma,it seprate out
> into LastnameFirstnameAddressApt/Suite #123CityStateZipcode
> but i need
#!/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
ankIT WALiA 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
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,