1. Fw: comma delimit, quote qualified.
- Posted by Lucius Hilley <l3euphoria at bellsouth.net> Jul 12, 2003
- 529 views
This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C347FF.B1AACFE0 charset="iso-8859-1" How quickly things are forgotten. Lucius L. Hilley III ----- Original Message ----- From: "Lucius L. Hilley III" <lhilley at cdc.net> To: "Euphoria Programming for MS-DOS" <EUPHORIA at LISTSERV.MUOHIO.EDU> Sent: Sunday, October 10, 1999 01:19 PM Subject: comma delimit, quote qualified. > CSV - Comma Separated Values. > Here are a few routines to nicely handle what you may be looking for. > Can handle properly formatted files without a hitch. > Can handle CSV files with and without quote qualifiers. > Can handle mixture of with and without the quotes. > The zip contains sample data and sample program. > The sample program can be removed and made the function renamed into > a .e include file. Includes the raw source that I wrote and > processed using version 2.11 of my macro preprocessor. > > usage: > > line = gets(file) --get a line from the file. > fields = CSV(line) --parses the line into separate fields. > > You can then convert any sequence of numbers "1234" into an > atom by including and using value(). > > Lucius L. Hilley III > lhilley at cdc.net lucius at ComputerCafeUSA.com > +----------+--------------+--------------+----------+ > | Hollow | ICQ: 9638898 | AIM: LLHIII | Computer | > | Horse +--------------+--------------+ Cafe' | > | Software | http://www.cdc.net/~lhilley | USA | > +----------+-------+---------------------+----------+ > | http://www.ComputerCafeUSA.com | > +--------------------------------+ > ----- Original Message ----- > From: Steven G Astley <sgastley at HOTMAIL.COM> > To: <EUPHORIA at LISTSERV.MUOHIO.EDU> > Sent: Sunday, October 10, 1999 8:46 AM > Subject: i'm confused? > > > > ---------------------- Information from the mail > header ----------------------- > > Sender: Euphoria Programming for MS-DOS > <EUPHORIA at LISTSERV.MUOHIO.EDU> > > Poster: Steven G Astley <sgastley at HOTMAIL.COM> > > Subject: i'm confused? > > -------------------------------------------------------------------------- > ----- > > > > Rob's helped some, thx Rob, ... but ... > > > > Can Euphoria(U4) handle business applications? > > I need to read ASCII, comma delimited files of several thousand > records > > with a dozen variable length fields, load into a table/array, massage the > > field data in many ways, do some statistical analysis and print a report. > > Is this possible? > > eg,record layout: date, var1, var2, var3, var4, var5, var6 > > > > Does anyone have an example of this type of processing? or portions there > > of? I don't understand how U4 can handle field processing. Can it? > > > > thx, sga > > > > ______________________________________________________ > > Get Your Private, Free Email at http://www.hotmail.com > > > ------=_NextPart_000_0013_01C347FF.B1AACFE0 Content-Type: application/x-zip-compressed; name="csv.zip"
2. Re: Fw: comma delimit, quote qualified.
- Posted by gertie at visionsix.com Jul 12, 2003
- 505 views
On 11 Jul 2003, at 22:56, Lucius Hilley wrote: > > How quickly things are forgotten. Why are you replying to the following emails with those dates?: > > ----- Original Message ----- > > From: Steven G Astley <sgastley at HOTMAIL.COM> > > To: <EUPHORIA at LISTSERV.MUOHIO.EDU> > > Sent: Sunday, October 10, 1999 8:46 AM Kat > Lucius L. Hilley III > > ----- Original Message ----- > From: "Lucius L. Hilley III" <lhilley at cdc.net> > To: "Euphoria Programming for MS-DOS" <EUPHORIA at LISTSERV.MUOHIO.EDU> > Sent: Sunday, October 10, 1999 01:19 PM > Subject: comma delimit, quote qualified. > > > > CSV - Comma Separated Values. > > Here are a few routines to nicely handle what you may be looking for. > > Can handle properly formatted files without a hitch. > > Can handle CSV files with and without quote qualifiers. > > Can handle mixture of with and without the quotes. > > The zip contains sample data and sample program. > > The sample program can be removed and made the function renamed into > > a .e include file. Includes the raw source that I wrote and > > processed using version 2.11 of my macro preprocessor. > > > > usage: > > > > line = gets(file) --get a line from the file. > > fields = CSV(line) --parses the line into separate fields. > > > > You can then convert any sequence of numbers "1234" into an > > atom by including and using value(). > > > > Lucius L. Hilley III > > lhilley at cdc.net lucius at ComputerCafeUSA.com > > +----------+--------------+--------------+----------+ > > | Hollow | ICQ: 9638898 | AIM: LLHIII | Computer | > > | Horse +--------------+--------------+ Cafe' | > > | Software | http://www.cdc.net/~lhilley | USA | > > +----------+-------+---------------------+----------+ > > | http://www.ComputerCafeUSA.com | > > +--------------------------------+ > > ----- Original Message ----- > > From: Steven G Astley <sgastley at HOTMAIL.COM> > > To: <EUPHORIA at LISTSERV.MUOHIO.EDU> > > Sent: Sunday, October 10, 1999 8:46 AM > > Subject: i'm confused? > > > > > > > ---------------------- Information from the mail > > header ----------------------- > > > Sender: Euphoria Programming for MS-DOS > > <EUPHORIA at LISTSERV.MUOHIO.EDU> > > > Poster: Steven G Astley <sgastley at HOTMAIL.COM> > > > Subject: i'm confused? > > > > -------------------------------------------------------------------------- > > ----- > > > > > > Rob's helped some, thx Rob, ... but ... > > > > > > Can Euphoria(U4) handle business applications? > > > I need to read ASCII, comma delimited files of several thousand > > records > > > with a dozen variable length fields, load into a table/array, massage > the > > > field data in many ways, do some statistical analysis and print a > report. > > > Is this possible? > > > eg,record layout: date, var1, var2, var3, var4, var5, var6 > > > > > > Does anyone have an example of this type of processing? or portions > there > > > of? I don't understand how U4 can handle field processing. Can it? > > > > > > thx, sga > > > > > > ______________________________________________________ > > > Get Your Private, Free Email at http://www.hotmail.com > > > > > > > > TOPICA - Start your own email discussion group. FREE! > >