It depends on what you want to do with it, but here's an idea.
<cfset loc_file_path=listdeleteat( getcurrenttemplatepath(), listlen(
getcurrenttemplatepath(), "\/" ), "\/" ) & "/temp/">
<cffile action="UPLOAD"
filefield="fileupload"
destination="#loc_file_path#mydatafile.cvs"
nameconflict="Overwrite">
<cfset end_of_line = Chr(10)>
<cffile action="READ"
file="#loc_file_path#mydatafile.cvs"
variable="DataFile">
<cfset clean_data_file = Replace(DataFile, "'", " ")>
<cfset data_line_array = ListToArray(clean_data_file, end_of_line)>
<cfset arraycount = #ArrayLen(data_line_array)#>
<cfloop index ="x" from="1" to="#arraycount#">
<cfset data_element_array = ListToArray(Data_Line_Array[x])>
<cfset elementarraycount = #ArrayLen(Data_Element_Array)#>
<cfif #data_element_array[1]# is "x">
<cfset element_1 = "">
<cfelse>
<cfset tmp_element_1 = '#data_element_array[1]#'>
<cfset element_1 =
'#preservesinglequotes(tmp_element_1)#'>
</cfif>
<cfif #data_element_array[2]# is "x">
<cfset element_2 = "">
<cfelse>
<cfset tmp_element_2 = '#data_element_array[2]#'>
<cfset element_2 =
'#preservesinglequotes(tmp_element_2)#'>
</cfif>
<cfif #data_element_array[3]# is "x">
<cfset element_3 = "">
<cfelse>
<cfset tmp_element_3 = '#data_element_array[3]#'>
<cfset element_3 =
'#preservesinglequotes(tmp_element_3)#'>
</cfif>
<cfif #data_element_array[4]# is "x">
<cfset element_4 = "">
<cfelse>
<cfset tmp_element_4 = '#data_element_array[4]#'>
<cfset element_4 =
'#preservesinglequotes(tmp_element_4)#'>
</cfif>
<cfif #data_element_array[5]# is "x">
<cfset element_5 = "">
<cfelse>
<cfset tmp_element_5 = '#data_element_array[5]#'>
<cfset element_5 =
'#preservesinglequotes(tmp_element_5)#'>
</cfif>
<cfif #data_element_array[6]# is "x">
<cfset element_6 = "">
<cfelse>
<cfset tmp_element_6 = '#data_element_array[6]#'>
<cfset element_6 =
'#preservesinglequotes(tmp_element_6)#'>
</cfif>
<cfif #data_element_array[7]# is "x">
<cfset element_7 = "">
<cfelse>
<cfset tmp_element_7 = '#data_element_array[7]#'>
<cfset new_element_7 =
RemoveChars(tmp_element_7,len(tmp_element_7),1)>
<cfset element_7 =
'#preservesinglequotes(tmp_element_7)#'>
</cfif>
<cfif #data_element_array[1]# is not "">
<cfquery datasource="xxx">
insert into XXX(xxx, xxx, xxx, xxx,
xxx, xxx, xxx)
VALUES('#element_1#', '#element_2#',
'#element_3#,
'#element_4#', '#element_5#',
'#element_6#',
'#element_7#')
</cfquery>
</cfif>
</cfloop>
-----Original Message-----
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 1:39 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] help reading a text file...
The only method i'm aware of is to use <cfhttp> then you can execute a query
off that. Looks like:
<cfhttp method="get"
url=http://www.yoursite.net/foo.txt (<--should be quotes around
that)
name="grabTextFile"
delimiter=",">
Then you can output it just like a cfquery like so:
<cfouput query="grabTextFile">#grabTextFile.columnName#</cfoutput>
Thats straight from the text book. I have not had opportunity to try this in
real life so I can't comment reliably on performance.
A.
----- Original Message -----
From: "Johnson, Michael" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 12:55 PM
Subject: [KCFusion] help reading a text file...
>
> what's the best way to read a very large tab delimeted text file?
>
> does cf.. read the whole file into one variable... how does this get
> effected if you're reading a large file?
>
>
> Mike Johnson
> Science Application International Corporation
> (757) 870-9165
> Emai: [EMAIL PROTECTED]
>
> <<Johnson, Michael.vcf>>
>
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
