In my own routine, a simply enquote all fields, whether they "need it" or not. Then I don't have to check if the fields truly need it, and the nets get flooded with 8 percent more characters... The email and net gods however, seem to be keeping up with my wasteful ways.
-----Original Message----- From: Kevin King <[email protected]> To: U2 Users List <[email protected]> Sent: Mon, Feb 6, 2012 4:02 pm Subject: Re: [U2] Building an Excel File The CSV format is really pretty simple. Commas between fields. If a field ontains a comma or quote it should be quoted. If a field contains a quote he quote should be doubled. Will is right that you have to use a haracter-stepping algorithm to parse it properly. But with these two ules in mind it's not hard to build. On Mon, Feb 6, 2012 at 4:46 PM, Wjhonson <[email protected]> wrote: > Commas embedded in text data should not be an issue for csv files. It's just an issue for those programmers who aren't using char-stepping routines to parse the data. You have to step char by char, not field by field as the state transition matrix is defined to parse only on strings quoted on both sides. Unfortunately programmers do things their own way and blame the format. The long and short is, the Iphone's built in viewer can handle embedded commas without any problem in the rendering, since we have them embedded in some fields as well and the rendering is not corrupted by that. -----Original Message----- From: Israel, John R. <[email protected]> To: U2 Users List <[email protected]> Sent: Mon, Feb 6, 2012 3:27 pm Subject: Re: [U2] Building an Excel File I have always tried to avoid csv files because we have all kinds of characters n our descriptions (commas, double and single quotes, etc.) It is also very asy to build a row of data with 254 delimiters, then simply convert @FMs to abs. That being said, do you have a good subroutine to build csv rows that will not et confused with commas or quotes in the data? I am willing to give this a ry. John Israel Sent from my iPhone On Feb 6, 2012, at 5:28 PM, "Wjhonson" <[email protected]> wrote: > Rebuild the files as csv files and they will open on the Iphone without any urther intervention This is what we do. ohn Israel enior ERP Developer Dayton Superior Corporation 125 Byers Rd Miamisburg, OH 45342 ffice: 937-866-0711 x44380 ax: 937-865-9182 [email protected] 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. ----Original Message----- From: Israel, John R. <[email protected]> To: 'U2 Users List' <[email protected]> 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 e 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 ll he bells and whistles that a full blown version of Excel has, thus undesirable esults. John -----Original Message----- rom: [email protected] [mailto: [email protected]] 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 nd 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: [email protected] [mailto: [email protected]] 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 [email protected] 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 otify 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 [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
