>From what I have seen Excel2010 (I think 2007 did it as well) will often strip off the first occurrence of the double quote in the field and leave the ending quote, but still get the columns right.
For instance: test,"he said, "Watch out below."","test2" Will show up as Col1 test Col2 he said, Watch out below."" Col3 test2 You have to escape them with an additional double quote to get it right This: test,"he said, ""Watch out below.""","test2" Works as expected. So the moral is, replace your double quotes with 2 double quotes before you write surround it with double quotes and write it. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Monday, February 06, 2012 5:45 PM To: U2 Users List Subject: Re: [U2] Building an Excel File It's been my experience in the past that you can avoid issues with the comma delimeter as long as you enclose your data in double-quotes. Supposedly this even applies to data that already contains double-quotes, although I've never attempted it personally. Wikipedia has that specific example documented, though: http://en.wikipedia.org/wiki/Comma-separated_values -John -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, February 06, 2012 3:26 PM To: U2 Users List Subject: Re: [U2] Building an Excel File I have always tried to avoid csv files because we have all kinds of characters in our descriptions (commas, double and single quotes, etc.) It is also very easy to build a row of data with 254 delimiters, then simply convert @FMs to tabs. That being said, do you have a good subroutine to build csv rows that will not get confused with commas or quotes in the data? I am willing to give this a try. John Israel Sent from my iPhone On Feb 6, 2012, at 5:28 PM, "Wjhonson" <wjhon...@aol.com> wrote: > > Rebuild the files as csv files and they will open on the Iphone > without any further intervention This is what we do. > > > > > John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. -----Original Message----- > From: Israel, John R. <johnisr...@daytonsuperior.com> > To: 'U2 Users List' <u2-users@listserver.u2ug.org> > Sent: Mon, Feb 6, 2012 2:25 pm > Subject: Re: [U2] Building an Excel File > > > No, the Smart Phones can not open the XML at all. The txt and xls > files can be pened, but they are just text. Managers want to be able > to read the files leanly. > I am guessing the issue is that when a smart phone opens a true Excel > file, it s not running Excel, but some sort of emulator. The emulator > does not have all he bells and whistles that a full blown version of > Excel has, thus undesirable esults. > John > > -----Original Message----- > rom: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] > n Behalf Of George Gallen > ent: Monday, February 06, 2012 4:45 PM > o: U2 Users List > ubject: Re: [U2] Building an Excel File Can they open an XML file > coded for Excel, but without formatting and colors and uch? > f so, you may just have to have two files produced, one for the phones > and one or desktops. > I haven't checked, but are there any perl modules that can convert an > XML file o an .xls file This would require unix, but not any user > intervention. > -----Original Message----- > rom: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] > n Behalf Of Israel, John R. > ent: Monday, February 06, 2012 4:40 PM > o: 'U2 Users List' > ubject: [U2] Building an Excel File > We are running UniData on a UNIX platform. We create tab-delimited > txt files and tab delimited txt files with xls extensions) all the > time that users open ith Excel. Many of these jobs are run in the > middle of the night or in a rigger program. In all cases, there is no > direct user interaction building hese files. > We also have some XML files that are coded so that Excel opens them > with ormatting, colors, filters, etc. > Unfortunately, our BB users and iPhone users can not open these files > up in a eaningful way. > Is there a way to build a TRUE Excel file without any user > intervention from niData or UNIX? > John > > > John Israel > enior ERP Developer > Dayton Superior Corporation > 125 Byers Rd Miamisburg, OH 45342 > ffice: 937-866-0711 x44380 > ax: 937-865-9182 > johnisr...@daytonsuperior.com > This message w/attachments (message) is intended solely for the use of > the ntended recipient(s) and may contain information that is > privileged, onfidential or proprietary. If you are not an intended > recipient, please notify he sender, and then please delete and destroy > all copies and attachments, and e advised that any review or > dissemination of, or the taking of any action in eliance on, the > information contained in or attached to this message is rohibited. > > > ______________________________________________ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > ______________________________________________ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
