Sorry, CF 4.5/5 and possibly MX. Also, the DB would be SQL Server 7/2000 or Oracle 8i or 9i.
Issac -----Original Message----- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 7:17 PM To: CF-Talk Subject: Re: Parsing a large text file Which version of CF? -- jon mailto:[EMAIL PROTECTED] Tuesday, June 10, 2003, 7:13:11 PM, you wrote: IR> What would be the best way to parse a large text file (>5mb)? Actually, IR> the text file is 1 large string. I need to create either a file with IR> each new record on a line or enter each new record into a table (new IR> record = every 60 chars). IR> Here's what I've tried, but there must be a more efficient way. IR> <cffile action="Read" IR> file="C:\temp\MATCHMST\MATCHMST.txt" IR> variable="message"> IR> <cfset recordLength = 60> IR> <cfset messageLen = Len(message)> IR> <cfset messageRecords = messageLen/recordLength> IR> <cfloop index="loopCount" from="1" to="#messageRecords#"> IR> <cfset new_record = Left(message, recordLength)> IR> <cfoutput>#new_record#<br></cfoutput> IR> <cfset message = RemoveChars(message, 1, recordLength)> IR> </cfloop> IR> <cfoutput> IR> File is done! IR> </cfoutput> IR> OR IR> <cffile action="append" IR> file="C:\temp\MATCHMST\NEW_MATCHMST.txt" IR> output="#new_record#" IR> addnewline="yes"> IR> OR IR> <cfquery name="insertRecord" datasource="db1"> IR> Insert into matchmst (matchmst) IR> Values ('#new_record#') IR> </cfquery> IR> Thanks, IR> Issac IR> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
