×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I also got hit by related quirks in Excel.
If it is not putting quote marks around your field, check to see what it
does when there are quotes in the data.
Also, when you save to a tab-delimited text file, usually my personal
preference, when there is any comma or quote in there it will put quotes
around that column in the .txt file, and any quotes inside will be
doubled up.
But does it distinguish all this when it reads it back in? Ooh, No. It
will keep the quotes around that column. However, if I strip the quotes
back out with RPG, download tab-delimited to the PC, then import to
Excel, it has no problem.
Surprises abound.
Alan
Jeff Crosby wrote:
I'm trying to save a spreadsheet in .csv format. The problem
is Excel does not put quotation marks around alpha fields.
Is there a way to make Excel do that? Office 2000.
Ha! I did it another way. Downloaded and installed OpenOffice. Opened the
.xls file, did a Save As .csv, it asked me what to use as delimiters, and
Voila!
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
