by howardg » Sat Sep 24, 2011 11:17 am
Thanks for your clear answer to my earlier question. I have run into a different problem now. After exporting the file, opening it in Excel (using the text import wizard), adding some words, saving as a text file, uploading to your site, and downloading to my iPhone, I find that dozens of the words have quotation marks around them where none had existed before. When I open the file in Excel I use the default settings for the import wizard, i.e., tab-delimited file, text qualifier = ", with "general" as the data format for all columns. I know this may be an Excel issue, but if you have any insight about where these unnecessary quote marks are coming from I would really appreciate it.
ADDITIONAL INFORMATION: After posting I did some additional investigation and discovered that the glitch comes at the point where I save the Excel spreadsheet to a text file. If any cell of the spreadsheet contains a comma, then that cell will export with the text surrounded by quote marks, e.g., [get, obtain] comes out as ["get, obtain"], but [get obtain] comes out as [get obtain]. What's up with that? I'd really like to be able to include commas without getting quotation marks.
Thanks for your clear answer to my earlier question. I have run into a different problem now. After exporting the file, opening it in Excel (using the text import wizard), adding some words, saving as a text file, uploading to your site, and downloading to my iPhone, I find that dozens of the words have quotation marks around them where none had existed before. When I open the file in Excel I use the default settings for the import wizard, i.e., tab-delimited file, text qualifier = ", with "general" as the data format for all columns. I know this may be an Excel issue, but if you have any insight about where these unnecessary quote marks are coming from I would really appreciate it.
ADDITIONAL INFORMATION: After posting I did some additional investigation and discovered that the glitch comes at the point where I save the Excel spreadsheet to a text file. If any cell of the spreadsheet contains a comma, then that cell will export with the text surrounded by quote marks, e.g., [get, obtain] comes out as ["get, obtain"], but [get obtain] comes out as [get obtain]. What's up with that? I'd really like to be able to include commas without getting quotation marks.
