Hi, all... I'm trying to read a tab-delimited text file of data and separate it into field data so I can input it into a database.
I can read the file, and output the entire contents, but nothing I tried worked to output the contents into separate pieces of data and separate records. The code below just outputs everything. Anyone have a little help for what I should add next to this code? (At first I'm just trying to separate the data into the individual parts for the fields and records...after that I can insert it into my db...) I picked up the code below online, but couldn't find a way to make it work. Thanks for any clues! Rick <cfset filepath = "e:\inetpub\webroot\real_estate_data\hmls\data\#DateFormat(now(), 'yyyy_mmdd')#_idx_custom\office.txt"> <cffile action = "read" file = "#filepath#" variable = "hmls_offices"> <cfloop index = "record" list = "hmls_offices" delimiters = "#chr(9)#, #chr(10)#"> <cfoutput>#hmls_offices#</cfoutput> </cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
