I need a perl script to end up with the following fields:
The csv file looks like this:
"Name","Company","Business Address","Business Phone","Business Fax","E-mail Address","Web Page"
"lname1, fname1 mi1","company name","address1,address2,city, state zip,United States of America","phone","fax","email","website"
The middle initial may or may not be there
Address 2 may or may not be there
The first line above is the first line of the CSV file, the 2nd line is actually the first line with data.
I do not need the country field from the listing
Country may or may not be listed.
Please PM me if you would like actual lines from the file, otherwise list your bid here. All I need is the lines parsed, I'll take care for reading it in from the file and the code to input the fields into the database.