I've created an *.csv file for importing into an application but the csv file won't import properly. I have to put quotes around the import fields due to commas being a 'possible' part of an address like "123 E Main St., Apt. 100B". Without commas the import performs properly.
Is this comment appropriate in this situation:
The problem seems to be that the application can’t import it in a standard txt/csv file. There has to be a code missing somewhere or an extra code somewhere, but I can’t see it. It works great if it reads it as an Excel csv file.
Are all *.csv files created equal or is there a 'special' *.csv from Excel?
Suggestions on a resolution...?