CF-Pros: I'd like to publicly acknowledge, and thank, Jim Curran and Ben Johnson for their assistance on this problem.
Jim, you nailed it -- I'd reversed the codes #chr(10)##chr(13)# instead of #chr(13)##chr(10)# ! I feel like such a dope: I examined two other programs that worked for previous projects and never saw that in this particular program I had reversed the codes. Talk about not seeing the "forest for the trees" ! Again, thank you, your assistance was much appreciated. Have a great day. -Gerry Gerard T. Pauline Mgr, Internet/DB Applications Computer Systems, DoIT Pace University Jim Curran wrote: > > <CFLOOP INDEX="row" LIST="#variables.WP_UPDATES#" > DELIMITERS="#chr(13)##chr(10)#"> > > 13 is CR > > 10 is LF > > See if that helps. > > - j > > -----Original Message----- > From: Gerry Pauline [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 09, 2002 4:45 PM > To: CF-Talk > Subject: Data From The Mainframe & Line Ending Codes > > CF-Pros: > > I'm trying to deal with a file generated on our mainframe with CFFILE. > I'm using CFFILE to read the contents into a variable and then parse out > the contents; CFFILE seems to be working fine. > > The code is pretty standard: > > <CFFILE ACTION="Read" > FILE="C:\InetPub\WWWroot\WhitePages\UpdateFiles\INTUPD.txt" > VARIABLE="WP_UPDATES"> > > The problem occurs when I try to parse out the records. I'm using the > following code, which is also pretty standard: > > <CFOUTPUT> > <CFLOOP INDEX="row" LIST="#variables.WP_UPDATES#" > DELIMITERS="#chr(10)##chr(13)#"> > #row# <P> > </CFLOOP> > </CFOUTPUT> > > A record looks like this: > > 01;003307198;LORE,IRENE SUSAN > ;A;6;20000907;20000907;00000000; ;[EMAIL PROTECTED] > ; ; > ;A;00000000;3601245 ;MANAGEMENT ; > > This is only one record, and most likely will wrap around on your screen > (the record length is 216 characters). > > It seems I don't have the correct codes to indicate the end of the > records. I've tried "chr(10)" and "chr(13)" separately, and in unison, > as in the above example. > > Does anyone out there in CFExpertLand know what the correct line ending > code would be ? > > Thank you. > > -Gerry > > Gerard T. Pauline > Mgr, Internet/DB Applications > Computer Systems, DoIT > Pace University > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists