Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to read a text file line by line and assign them to variables?
- Thread starter accuransx
- Start date
You can use [tt]<CFHTTP>[tt] to "query" the text file.
CFHub has great tutorial on this:
- tleish
CFHub has great tutorial on this:
- tleish
- Thread starter
- #3
Why my CF Server cannot recognize my CFHTTP tag as a query? I got this error msg:
Error Diagnostic Information
QUERY
The QUERY attribute of the tag does not specify the name of an available query
The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (9:1) to (9:29).
Date/Time: 10/09/01 16:56:18
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 192.168.0.1
HTTP Referer:
Error Diagnostic Information
QUERY
The QUERY attribute of the tag does not specify the name of an available query
The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (9:1) to (9:29).
Date/Time: 10/09/01 16:56:18
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 192.168.0.1
HTTP Referer:
- Thread starter
- #5
This is my code:
---start-of-page---
Upload
<CFHTTP url=" method="get" delimiter="," textqualifier="""" columns="a,b" name="UploadData">
<CFOUTPUT>
No. of Records : #UploadData.RecordCount# records
</cfoutput>
<cfoutput query="UploadData">
<BR>#a# #b#<br>
</cfoutput>
</cfhttp>
<!---
I've tried this code before, but failed to chop the data.
I was trying to read from a text file and copy the data to my Access DB
<cffile action="READ" file="D:\Applications\Kuittho\Data\data001.txt" variable="FNama">
<cfoutput>#LTRIM(FNama)#</cfoutput>
--->
---end-of-page---
---start-of-page---
Upload
<CFHTTP url=" method="get" delimiter="," textqualifier="""" columns="a,b" name="UploadData">
<CFOUTPUT>
No. of Records : #UploadData.RecordCount# records
</cfoutput>
<cfoutput query="UploadData">
<BR>#a# #b#<br>
</cfoutput>
</cfhttp>
<!---
I've tried this code before, but failed to chop the data.
I was trying to read from a text file and copy the data to my Access DB
<cffile action="READ" file="D:\Applications\Kuittho\Data\data001.txt" variable="FNama">
<cfoutput>#LTRIM(FNama)#</cfoutput>
--->
---end-of-page---
The closing </CFHTTP> is in the wrong place.
Try:
<CFHTTP URL=" METHOD="get" DELIMITER=","
TEXTQUALIFIER="""" COLUMNS="a,b"
NAME="UploadData"/>[COLOR=666666]<!--- /> is the same as </CFHTTP> --->[/color]
<CFOUTPUT>
No. of Records : #UploadData.RecordCount# records
</CFOUTPUT>
<CFOUTPUT QUERY="UploadData">
[COLOR=000080]<BR>[/color]#a# #b#[COLOR=000080]<BR>[/color]
</CFOUTPUT>
[COLOR=666666]<!---</CFHTTP> This is in the wrong place --->[/color] - tleish
Try:
<CFHTTP URL=" METHOD="get" DELIMITER=","
TEXTQUALIFIER="""" COLUMNS="a,b"
NAME="UploadData"/>[COLOR=666666]<!--- /> is the same as </CFHTTP> --->[/color]
<CFOUTPUT>
No. of Records : #UploadData.RecordCount# records
</CFOUTPUT>
<CFOUTPUT QUERY="UploadData">
[COLOR=000080]<BR>[/color]#a# #b#[COLOR=000080]<BR>[/color]
</CFOUTPUT>
[COLOR=666666]<!---
- Thread starter
- #7
Still cannot recognize my UploadData query. Err msg:
Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while evaluating the expression:
#UploadData.RecordCount#
Error near line 8, column 19.
--------------------------------------------------------------------------------
Error resolving parameter UPLOADDATA.RECORDCOUNT
ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:
You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.
The error occurred while processing an element with a general identifier of (#UploadData.RecordCount#), occupying document position (8:18) to (8:41).
Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while evaluating the expression:
#UploadData.RecordCount#
Error near line 8, column 19.
--------------------------------------------------------------------------------
Error resolving parameter UPLOADDATA.RECORDCOUNT
ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:
You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.
The error occurred while processing an element with a general identifier of (#UploadData.RecordCount#), occupying document position (8:18) to (8:41).
- Thread starter
- #9
This is my dummy data from data001.txt:
"AAA","Sudah Lulus"
"ABC","Tidak Lulus"
"DEF","Sudah Lulus"
"GHI","Tidak Lulus"
"KLM","Sudah Lulus"
"AAA","Sudah Lulus"
"ABC","Tidak Lulus"
"DEF","Sudah Lulus"
"GHI","Tidak Lulus"
"KLM","Sudah Lulus"
Using:
<CFHTTP URL="
"
METHOD="get" DELIMITER=","
TEXTQUALIFIER="""" COLUMNS="a,b"
NAME="UploadData"/>
<CFOUTPUT>
No. of Records : #UploadData.RecordCount# records
</CFOUTPUT>
<CFOUTPUT QUERY="UploadData">
[COLOR=000080]<BR>[/color]#a# #b#[COLOR=000080]<BR>[/color]
</CFOUTPUT>
With a txt file:
[tt]dummy text
"AAA","Sudah Lulus"
"ABC","Tidak Lulus"
"DEF","Sudah Lulus"
"GHI","Tidak Lulus"
"KLM","Sudah Lulus"[tt]
Worked fine for me, it printed:
No. of Records : 4 records
ABC Tidak Lulus
DEF Sudah Lulus
GHI Tidak Lulus
KLM Sudah Lulus - tleish
<CFHTTP URL="
Code:
[URL unfurl="true"]http://badang:301/data/data001.txt[/URL]METHOD="get" DELIMITER=","
TEXTQUALIFIER="""" COLUMNS="a,b"
NAME="UploadData"/>
<CFOUTPUT>
No. of Records : #UploadData.RecordCount# records
</CFOUTPUT>
<CFOUTPUT QUERY="UploadData">
[COLOR=000080]<BR>[/color]#a# #b#[COLOR=000080]<BR>[/color]
</CFOUTPUT>
With a txt file:
[tt]dummy text
"AAA","Sudah Lulus"
"ABC","Tidak Lulus"
"DEF","Sudah Lulus"
"GHI","Tidak Lulus"
"KLM","Sudah Lulus"[tt]
Worked fine for me, it printed:
No. of Records : 4 records
ABC Tidak Lulus
DEF Sudah Lulus
GHI Tidak Lulus
KLM Sudah Lulus - tleish
Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
I've had a very similar problem. I was uploading the CSV file using a web page. Using your test data, and assuming you called the file upload element of the form "datafile" (i.e. <INPUT TYPE="FILE" NAME="datafile"> ) you could use the following code:
Setting the delimiters to Chr(10) and Chr(13) catches end-of-line characters. Of course, this still leaves the double-quotes. To remove them you could do something like:
Alternatively you could combine the ListGetAt and the Replace to give you:
Hope this helps.
Scott.
Code:
<CFLOOP INDEX="Line" LIST="#Form.datafile#"
DELIMITERS="#Chr(10)##Chr(13)#">
<CFSET IDcode = ListGetAt(Line,1)>
<CFSET Name = ListGetAt(Line,2)>
</CFLOOP>
Code:
<CFSET IDcode = Replace(IDcode,'"','','ALL')>
Code:
<CFSET IDcode = Replace(ListGetAt(Line,1),'"','','ALL')>Scott.
- Thread starter
- #12
gunawandjon
MIS
Try this conventional way
<cfset crlf = chr(13) & chr (10)>
<cffile action="READ" file="data001.txt" variable="filecontents">
<CFOUTPUT>
No. of Records : #listlen(filecontents,crlf)# records
</CFOUTPUT>
<cfloop list="#filecontents#" delimiters="#crlf#" index="logline">
<BR>#listgetat(logline,1,","
# #listgetat(logline,2,","#<BR>
</cfloop>
<cfset crlf = chr(13) & chr (10)>
<cffile action="READ" file="data001.txt" variable="filecontents">
<CFOUTPUT>
No. of Records : #listlen(filecontents,crlf)# records
</CFOUTPUT>
<cfloop list="#filecontents#" delimiters="#crlf#" index="logline">
<BR>#listgetat(logline,1,","
# #listgetat(logline,2,","#<BR> </cfloop>
- Thread starter
- #14
I get this respond:
Upload No. of Records : 6 records
"AAA" "Sudah Lulus"
"ABC" "Tidak Lulus"
"DEF" "Sudah Lulus"
"GHI" "Tidak Lulus"
"KLM" "Sudah Lulus"
--------------------------------------------------------------------------------
Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while evaluating the expression:
#listgetat(logline,2,","#
Error near line 10, column 33.
--------------------------------------------------------------------------------
In function ListGetAt(list, index [, delimiters]) the value of index, which is 2, is not a valid index for the list given as a the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list
The error occurred while processing an element with a general identifier of (#listgetat(logline,2,","#), occupying document position (10:32) to (10:57).
I think my last loop/termination point problem. If it works i need to assign this to variable and then upload the stored value in my SQL tables. Any easier way?
Upload No. of Records : 6 records
"AAA" "Sudah Lulus"
"ABC" "Tidak Lulus"
"DEF" "Sudah Lulus"
"GHI" "Tidak Lulus"
"KLM" "Sudah Lulus"
--------------------------------------------------------------------------------
Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while evaluating the expression:
#listgetat(logline,2,","
#Error near line 10, column 33.
--------------------------------------------------------------------------------
In function ListGetAt(list, index [, delimiters]) the value of index, which is 2, is not a valid index for the list given as a the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list
The error occurred while processing an element with a general identifier of (#listgetat(logline,2,","
#), occupying document position (10:32) to (10:57).I think my last loop/termination point problem. If it works i need to assign this to variable and then upload the stored value in my SQL tables. Any easier way?
gunawandjon
MIS
Sorry,
The loop section should be
<cfloop list="#filecontents#" delimiters="#crlf#" index="logline">
<BR>#listgetat(filecontents,1,","# #listgetat(filecontents,2,","#<BR>
</cfloop>
The above loop will display the result, if you want to insert into a table/database, use cfquery inside the loop.
<cfloop list="#filecontents#" delimiters="#crlf#" index="logline">
<cfquery name="namaquery" datasource="namadatasource">
INSERT INTO namatable (namafiled1, namafield2)
VALUES (#listgetat(filecontents,1,","#,#listgetat(filecontents,2,","#)
</cfquery>
</cfloop>
The loop section should be
<cfloop list="#filecontents#" delimiters="#crlf#" index="logline">
<BR>#listgetat(filecontents,1,","
# #listgetat(filecontents,2,","#<BR> </cfloop>
The above loop will display the result, if you want to insert into a table/database, use cfquery inside the loop.
<cfloop list="#filecontents#" delimiters="#crlf#" index="logline">
<cfquery name="namaquery" datasource="namadatasource">
INSERT INTO namatable (namafiled1, namafield2)
VALUES (#listgetat(filecontents,1,","
#,#listgetat(filecontents,2,","#)</cfquery>
</cfloop>
- Thread starter
- #16
I moved </cfoutput> to the right place, so my new code:
<cfset crlf = chr(13) & chr (10)>
<cffile action="READ" file="D:\Applications\Kuittho\Data\data001.txt" variable="filecontents">
<CFOUTPUT>
No. of Records : #listlen(filecontents,crlf)# records
<cfloop list="#filecontents#" delimiters="#crlf#" index="logline">
<BR>#listgetat(filecontents,1,","# #listgetat(filecontents,2,","#<BR>
</cfloop>
</CFOUTPUT>
but i only have the wrong result like this:
No. of Records : 7 records
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
<cfset crlf = chr(13) & chr (10)>
<cffile action="READ" file="D:\Applications\Kuittho\Data\data001.txt" variable="filecontents">
<CFOUTPUT>
No. of Records : #listlen(filecontents,crlf)# records
<cfloop list="#filecontents#" delimiters="#crlf#" index="logline">
<BR>#listgetat(filecontents,1,","
# #listgetat(filecontents,2,","#<BR> </cfloop>
</CFOUTPUT>
but i only have the wrong result like this:
No. of Records : 7 records
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
"AAA" "Sudah Lulus" "ABC"
- Thread starter
- #17
- Status
Similar threads
- Locked
- Question