Re: parsing records

2004-06-10 Thread James Edward Gray II
On Jun 10, 2004, at 8:13 AM, Virmani, Amit (GMI Debt Technology) wrote: I am a novice in Perl... I have a file with records of fields in double quotes separated by commas, for example: "abc","123xyz","Test 1","Test 2","100,000"... What you describe is the CSV file format and there's really no good

parsing records

2004-06-10 Thread Virmani, Amit (GMI Debt Technology)
I am a novice in Perl... I have a file with records of fields in double quotes separated by commas, for example: "abc","123xyz","Test 1","Test 2","100,000"... I need to remove the double quotes from the records and insert this data into database using bulk copy using comma as the delimeter. Since