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 to store data into
> LastnameFirstnameAddress, Apt/Suite #123CityStateZipcode
> I am usingvar oFile = Clib.fopen(vFilepath,"r");var string =
> (Clib.fgets(oFile));                        if(string)               
>         {                           var arr = string.split(",");     
>                   } Please suggest something......

Something like this?

echo 'recordLastname,Firstname,"Address, Apt/Suite 
#123",City,State,Zipcodewhen'| \
perl -MText::CSV -e \
'$c=Text::CSV_XS->new();$s=$c->parse(<STDIN>);@c=$c->fields;map{print "$_\n"} 
@c;'

recordLastname
Firstname
Address, Apt/Suite #123
City
State
Zipcodewhen

Regards,

-- Raju
-- 
Raj Mathur           [EMAIL PROTECTED]   http://kandalaya.org/
       GPG: 78D4 FC67 367F 40E2 0DD5  0FEF C968 D0EF CC68 D17F
                      It is the mind that moves

_______________________________________________
ilugd mailinglist -- ilugd@lists.linux-delhi.org
http://frodo.hserus.net/mailman/listinfo/ilugd
Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi 
http://www.mail-archive.com/ilugd@lists.linux-delhi.org/

Reply via email to