Lonnie Drew said: "...my eyes are crossed now, but I think there's an
explanation
somewhere above."
Good--I don't feel all alone now. :-) Tons of new doors just
opened for me. I really appreciate the help and explanation.
Alan
-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Tuesday, September 24, 2002 12:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OT Crystal Reports--Concatenate multiple records
into one
Doesn't seem to make sense, does it.. You would think a "while"
or "until" argument would be necessary, or something like "while EOF
() = no".
Progress help on "repeat" statement says....
"Begins a block of statements that are processed repeatedly until the
block ends in one of several ways."
Progress help on the "Input From" statement, says...
"If end of file is reached, Progress responds as if you pressed
ENDKEY."
ENDKEY is to undo all the processing in the current iteration of the
block, then leave the block and continue on to any remaining
statements in the procedure. "
...my eyes are crossed now, but I think there's an explanation
somewhere above.
explanation
somewhere above."
Good--I don't feel all alone now. :-) Tons of new doors just
opened for me. I really appreciate the help and explanation.
Alan
-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Tuesday, September 24, 2002 12:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OT Crystal Reports--Concatenate multiple records
into one
Doesn't seem to make sense, does it.. You would think a "while"
or "until" argument would be necessary, or something like "while EOF
() = no".
Progress help on "repeat" statement says....
"Begins a block of statements that are processed repeatedly until the
block ends in one of several ways."
Progress help on the "Input From" statement, says...
"If end of file is reached, Progress responds as if you pressed
ENDKEY."
>From help on "On EndKey" phrase.."If you use a REPEAT or FOR EACH block, the default processing for
ENDKEY is to undo all the processing in the current iteration of the
block, then leave the block and continue on to any remaining
statements in the procedure. "
...my eyes are crossed now, but I think there's an explanation
somewhere above.
--- In vantage@y..., "Alan Williams" <awilliams@s...> wrote:
> Many Thanx!!! That got it. Could I get you to give me a down
and dirty
> explain on the repeat loop you have running here?
> Alan
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Tuesday, September 24, 2002 11:18 AM
> To: vantage@y...
> Subject: [Vantage] Re: OT Crystal Reports--Concatenate multiple
records
> into one
>
>
> I was close the first time, but newline and outline defaulted to 8
> chars and I forgot to skip to next line. I tried this one and it
> worked for me. If problems, send me your code and I'll take a
look.
>
> /* begin code */
> def var newline as char format "x(256)".
> def var outline as char format "x(768)".
> def var linecount as integer init 0.
> output to c:\LogOut.txt.
> output close.
> /* import the log file */
> input from c:\LogIn.txt.
> repeat:
> --import unformatted newline.
> --outline = outline + newline + " ".
> --linecount = linecount + 1.
> --if linecount >= 3 then do:
> ----output to c:\LogOut.txt append.
> ----put outline at 1 skip(0).
> ----output close.
> ----outline = "".
> ----linecount = 0.
> --end.
> end.
> /* end code */
>
>
> --- In vantage@y..., "Alan Williams" <awilliams@s...> wrote:
> > Cool idea, Lonnie. I wouldn't have thought to try this from
> Progress.
> > I'm running your code verbatim except for filenames, no dashes,
and
> the
> > addition of a "quit" statement at the end, but all I get in my
> output file
> > is a series of carriage returns. Here's the shortcut
properties
> for the
> > .p file: "V:\progress\bin\prowin32.exe -p
V:\vantage\Spamlog.p".
> >
> > Thanx for the help,
> > Alan
> > -----Original Message-----
> > From: Lonnie Drew [mailto:lonniedrew@c...]
> > Sent: Tuesday, September 24, 2002 8:53 AM
> > To: vantage@y...
> > Subject: [Vantage] Re: OT Crystal Reports--Concatenate
multiple
> records
> > into one
> >
> >
> > Alan,
> >
> > Crystal is not my forte, but here's Progress code you can run
from
> > the Vantage menu to concatenate the three lines to one
(ignore the
> > dashes, "-", there for alignment)...
> >
> > /* create c:\LogOut.txt. save the following as
c:\SomeThing.p */
> > /* begin code */
> > def var newline as char.
> > def var outline as char.
> > def var linecount as integer init 0.
> > /* import the log file */
> > input from c:\LogIn.txt.
> > repeat:
> > --import unformatted newline.
> > --outline = outline + newline + " ".
> > --linecount = linecount + 1.
> > --if linecount >= 3 then do:
> > ----output to c:\LogOut.txt append.
> > ----put outline at 1.
> > ----output close.
> > ----outline = "".
> > ----linecount = 0.
> > --end.
> > end.
> > /* end code */
> >
> > I would import into Excel for viewing.
> >
> > Hope This Helps,
> >
> > Lonnie
> >
> > --- In vantage@y..., "Alan Williams" <awilliams@s...> wrote:
> > > Anybody....anybody...anybody?
> > > -----Original Message-----
> > > From: Alan Williams [mailto:awilliams@s...]
> > > Sent: Monday, September 23, 2002 3:16 PM
> > > To: vantage@Yahoogroups. com
> > > Subject: [Vantage] OT Crystal Reports--Concatenate
multiple
> > records into
> > > one
> > >
> > >
> > > Howdy, all.
> > > I'm trying to use Crystal to examine our
> > spam filter
> > > log file (text file generated by Linux) Each record
actually
> > spans 3
> > > lines,
> > > and I need Crystal to consider the 3 as 1. I've been
> working on
> > this
> > > since
> > > lunch, without any luck. Anybody got any pointers?
> > > Thanx,
> > > Alan
> > > awilliams@s...
> > > 870-269-8108 ext 2016
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > > Yahoo! Groups Sponsor
> > > ADVERTISEMENT
> > >
> > >
> > >
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are:
Note:
> You
> > must
> > > have already linked your email address to a yahoo id to
enable
> > access. )
> > > (1) To access the Files Section of our Yahoo!Group for
Report
> > Builder and
> > > Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services
> goto:
> > > http://groups.yahoo.com/group/vantage/links
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms
of
> > Service.
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services
goto:
> > http://groups.yahoo.com/group/vantage/links
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
> >
> >
> >
> > [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]