Reading a file one line at a time with CFfile?

2000-09-30 Thread Terry - it-werks.com
I have a text file that is 1315 characters wide, which is an exported Cobol database that I reed to go through one record/line at a time and do some mid() calls to retreive certain fields and insert them into an Access table. I am unsure how to walk thru the file line by line. I do know how to

Re: Reading a file one line at a time with CFfile?

2000-09-30 Thread Jim McAtee
With CFFILE you're only able to read the entire file into a variable. Treat the file contents as a list, using carriage returns and/or line feeds as delimiters. Because of the way CF handles lists and delimiters, the following code works regardless of whether carriage returns, line feeds or any

Re: Reading a file one line at a time with CFfile?

2000-09-30 Thread Terry - it-werks.com
Jim, Thanks for the lightening quick reply. I totally forgot about the carraige return. I will work with your method as it sure looks sound. Thanks again Terry Troxel - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Cc: "Terry - it-werks.com"