<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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
