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
