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 one of fields (field#5) has a comma as part of the text, I was having difficulty
parsing this data as this comma would split the field
into two separate fields and cause my bulk copy to fail due to field mismatch. I want
to get rid of this extra comma (if it exists) so that the record looks like:
abc,123xyz,Test 1,Test 2,100000...
Any solutions...
Thanks,
- Amit
==============================================================================
If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.
Click here for important additional terms relating to this e-mail.
<http://www.ml.com/email_terms/>
==============================================================================
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
