Re: [ilugd] How to remove comma(') from CSV file

2007-07-01 Thread ankIT WALiA
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 comma,it

[ilugd] How to remove comma(') from CSV file

2007-06-29 Thread ankIT WALiA
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,

Re: [ilugd] How to remove comma(') from CSV file

2007-06-29 Thread Sandip Bhattacharya
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 need to store

Re: [ilugd] How to remove comma(') from CSV file

2007-06-29 Thread Saleem Ansari
#!/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,

Re: [ilugd] How to remove comma(') from CSV file

2007-06-29 Thread Raj Mathur
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