I would never suggest doing text manipulation in CF. In the case of parsing
mainframe data, I would use perl and perl-db to parse it and dump it into
your datasource. CF is primarily a display language, and while it does have
some nice data-crunching features, the sign of a strong engineer is knowing
when to use what tool in your kit!
----- Original Message -----
From: "Consultant" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, November 27, 2000 10:58 AM
Subject: RE: CFFILE reading line by line?
>
> Yup,
> u are right, teoritically I can do the same thing using CFFILE (which i
did
> actually). HOWEVER,
> u might end up with 10 - 20 CFloops and more than 30 regular expressions
to
> catch the data delimited by fixed width and fixed number of empty spaces.
It
> was totally unpractical.
>
> If CFFile able to put each line it reads into Array (like PHP), it will
make
> our life much more easier.
>
> There are <CR><LF> contains in the data columns of the mainframe dump, so,
> delimited the lines by <CR><LF> is impossible (DOH!!!!).
>
> CF is good in db abstraction, but i highly recommend PHP or perl for text
> manipulation, (don't get me wrong, I'm a hard cord CF supporter too). Hey,
> Nothing is perfect ;)
>
>
> regards,
>
> fong
>
>
> -----Original Message-----
> From: Matt Stueve [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 27, 2000 11:41 PM
> To: CF-Server
> Subject: RE: CFFILE reading line by line?
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C05887.65640520
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> Correct me if I'm wrong, but couldn't you read in a file, store it as a
> variable, and cfloop over it, with the delimiters being a new line? You'd
> then have each line to work with...
>
>
>
> -----Original Message-----
> From: Consultant [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 27, 2000 8:46 AM
> To: CF-Server
> Subject: RE: CFFILE reading line by line?
>
>
> I think Allaire need to do something about this feature, I've been writing
> backend scripts which take mainframes output into PC. CFFile just doesn't
> work. Immagine the content of the mainframe output, the columns are
> delimited by fixed length, and some delimited by empty spaces....
>
> CFFile is too stupid to handle text file like such, therefore, I have to
use
> PHP, and I highly recommend anyone need to deal with text file
manipulation
> uses PHP.
>
> cheers,
>
>
>
> -----Original Message-----
> From: Dusty Tinashe [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 27, 2000 6:19 PM
> To: CF-Server
> Subject: CFFILE reading line by line?
>
>
> Can it read line by line?
>
> ***********************************************************
> "There is nothing in a caterpillar that tells you it's going
> to be a butterfly."
> ***********************************************************
> "In life you are given two ends, one to think with and the
> other to sit on. Your success in life depends on which end you use most.
> Heads you win, tails you lose."
> --Conrad Burns, US Senator - Montana
> ***********************************************************
> "People are lonely because they build walls
> instead of bridges."
> --Unknown
> ***********************************************************
> Dusty Tinashe Shoko
> Web Applications Developer
> SARDC www.sardc.net
> 13 Bath Rd
> Belgravia, Harare
> Zimbabwe
> Tel: +263 (4) 738694/5/6
> Fax: +263 (4) 738693
> ***********************************************************
>
> --------------------------------------------------------------------------
--
> --
> To unsubscribe, send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
> --------------------------------------------------------------------------
--
> --
> To unsubscribe, send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
> ------_=_NextPart_001_01C05887.65640520
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
> 5.5.2650.12">
> <TITLE>RE: CFFILE reading line by line?</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT SIZE=3D2>Correct me if I'm wrong, but couldn't you read in a =
> file, store it as a variable, and cfloop over it, with the delimiters =
> being a new line? You'd then have each line to work =
> with...</FONT></P>
> <BR>
> <BR>
>
> <P><FONT SIZE=3D2>-----Original Message-----</FONT>
> <BR><FONT SIZE=3D2>From: Consultant [<A =
> HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]=
> </A>]</FONT>
> <BR><FONT SIZE=3D2>Sent: Monday, November 27, 2000 8:46 AM</FONT>
> <BR><FONT SIZE=3D2>To: CF-Server</FONT>
> <BR><FONT SIZE=3D2>Subject: RE: CFFILE reading line by line?</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=3D2>I think Allaire need to do something about this =
> feature, I've been writing</FONT>
> <BR><FONT SIZE=3D2>backend scripts which take mainframes output into =
> PC. CFFile just doesn't</FONT>
> <BR><FONT SIZE=3D2>work. Immagine the content of the mainframe output, =
> the columns are</FONT>
> <BR><FONT SIZE=3D2>delimited by fixed length, and some delimited by =
> empty spaces....</FONT>
> </P>
>
> <P><FONT SIZE=3D2>CFFile is too stupid to handle text file like such, =
> therefore, I have to use</FONT>
> <BR><FONT SIZE=3D2>PHP, and I highly recommend anyone need to deal with =
> text file manipulation</FONT>
> <BR><FONT SIZE=3D2>uses PHP.</FONT>
> </P>
>
> <P><FONT SIZE=3D2>cheers,</FONT>
> </P>
> <BR>
> <BR>
>
> <P><FONT SIZE=3D2>-----Original Message-----</FONT>
> <BR><FONT SIZE=3D2>From: Dusty Tinashe [<A =
> HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
> <BR><FONT SIZE=3D2>Sent: Monday, November 27, 2000 6:19 PM</FONT>
> <BR><FONT SIZE=3D2>To: CF-Server</FONT>
> <BR><FONT SIZE=3D2>Subject: CFFILE reading line by line?</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=3D2>Can it read line by line?</FONT>
> </P>
>
> <P><FONT =
> SIZE=3D2>***********************************************************</FO=
> NT>
> <BR><FONT SIZE=3D2>"There is nothing in a caterpillar that tells =
> you it's going</FONT>
> <BR><FONT SIZE=3D2>to be a butterfly."</FONT>
> <BR><FONT =
> SIZE=3D2>***********************************************************</FO=
> NT>
> <BR><FONT SIZE=3D2>"In life you are given two ends, one to think =
> with and the</FONT>
> <BR><FONT SIZE=3D2>other to sit on. Your success in life depends =
> on which end you use most.</FONT>
> <BR><FONT SIZE=3D2>Heads you win, tails you lose."</FONT>
> <BR><FONT SIZE=3D2>--Conrad Burns, US Senator - Montana</FONT>
> <BR><FONT =
> SIZE=3D2>***********************************************************</FO=
> NT>
> <BR><FONT SIZE=3D2>"People are lonely because they build =
> walls</FONT>
> <BR><FONT SIZE=3D2>instead of bridges."</FONT>
> <BR><FONT SIZE=3D2>--Unknown</FONT>
> <BR><FONT =
> SIZE=3D2>***********************************************************</FO=
> NT>
> <BR><FONT SIZE=3D2> Dusty Tinashe Shoko</FONT>
> <BR><FONT SIZE=3D2> Web Applications Developer</FONT>
> <BR><FONT SIZE=3D2> SARDC www.sardc.net</FONT>
> <BR><FONT SIZE=3D2> 13 Bath Rd</FONT>
> <BR><FONT SIZE=3D2> Belgravia, Harare</FONT>
> <BR><FONT SIZE=3D2> Zimbabwe</FONT>
> <BR><FONT SIZE=3D2> Tel: +263 (4) 738694/5/6</FONT>
> <BR><FONT SIZE=3D2> Fax: +263 (4) 738693</FONT>
> <BR><FONT =
> SIZE=3D2>***********************************************************</FO=
> NT>
> </P>
>
> <P><FONT =
> SIZE=3D2>---------------------------------------------------------------=
> -------------</FONT>
> <BR><FONT SIZE=3D2>--</FONT>
> <BR><FONT SIZE=3D2>To unsubscribe, send a message to =
> [EMAIL PROTECTED] with</FONT>
> <BR><FONT SIZE=3D2>'unsubscribe' in the body or visit the list page at =
> www.houseoffusion.com</FONT>
> </P>
>
> <P><FONT =
> SIZE=3D2>---------------------------------------------------------------=
> ---------------</FONT>
> <BR><FONT SIZE=3D2>To unsubscribe, send a message to =
> [EMAIL PROTECTED] with 'unsubscribe' in the body or =
> visit the list page at www.houseoffusion.com</FONT></P>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01C05887.65640520--
> --------------------------------------------------------------------------
--
> --
> To unsubscribe, send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
> --------------------------------------------------------------------------
----
> To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
>
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
