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
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
