The CSV format is really pretty simple. Commas between fields. If a field contains a comma or quote it should be quoted. If a field contains a quote the quote should be doubled. Will is right that you have to use a character-stepping algorithm to parse it properly. But with these two rules in mind it's not hard to build.
On Mon, Feb 6, 2012 at 4:46 PM, Wjhonson <wjhon...@aol.com> 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. <johnisr...@daytonsuperior.com> > To: U2 Users List <u2-users@listserver.u2ug.org> > 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" <wjhon...@aol.com> 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 > 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. > > > ----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 > 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: 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 > 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: 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 > 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 > 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 > > ______________________________________________ > 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
