Re: COMMA DELIMITED FILES

[Tony DeLia <tdelia@EROLS.COM>]

Hi Julie,

Creating delimited files is pretty easy... If you need to read and parse
delimited files you can find examples on my web-site:

   http://www.sqrtools.com

There's a page dedicated to reading comma-delimited files... You'll also
find an SQR function library (tdfunc.sqc) on the SQL*Engine page that
has a more robust version of a Parsing routine (PARSE-Func-Put and
PARSE-Func-Get) which allows you to designate the delimiter and text
qualifier used.

Since you're new to SQR you'll find alot of useful material
(utilities/techniques/info)... it's a resource that deals almost
exclusively with the creative aspects of SQR and PeopleSoft... i.e. no
syntax or material found in manuals... and I post updates frequently...

   Cheers,

      Tony DeLia

PS - And 'SQR in PeopleSoft and Other Applications' is a great
reference... as is the SQRUG site...

> > Hi,
> >
> > This is probably a basic question for most of you
> but I am a very new user
> > to SQR.
> >
> > I am using SQR to generate flat files.  I am
> selecting data from a Sybase
> > database.  How can I generate the file so that the
> data items are comma
> > delimited?  I can't find anything in the manuals
> about this.
> >
> > Thanks
> >
> > Julie

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com
http://www.sqrtools.com