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