CFHTTP get file problem

[cjdunkerley]

Hi,

I have code to read a text file on my server and process it into a database,
this works fine. The text file comes from a remote server that I I currently
have to copy and paste the text file from.

I have been trying to use cfhttp to get the file but it gets the html version
of the file and not what is being displayed, i.e the file contains <br> at the
end of the lines. This is causing errors when I use the 'name' variable and
also if I try to read the file after saving http.filecontent.

Everything works fine if I copy and paste the data from the page!

I know there must be a way to automate this but I can not find it... any help
is appreciated.

Regards,
Chris.

[Stressed_Simon]

After you read the file use Replace() to change the <br> tags to Carriage return line feeds.

ie <cfset myText = Replace(CFHTTP.FileContent, Chr(13) & Chr(10), "ALL")>

[cjdunkerley]

Thanks Simon,

It now works! Code for reference:

<cfhttp method="post" url="http://xxxxxxx/FILES/csv.cfm" timeout="1000">
<cfhttpparam type="formfield" name="UserLogin" value="xxxxx">
<cfhttpparam type="formfield" name="UserPassword" value="xxxxx">
</cfhttp>

<cfset p_data = Replacenocase(CFHTTP.FileContent, "<br>", Chr(13) & Chr(10),
"ALL")>
<cffile action="write" file="xxxxx\msepdata_test1.txt"
nameconflict="overwrite" output="#p_data#">

<cfx_text2query file="xxxx/msepdata_test1.txt"
firstRowIsHeader="true" rQuery="rsPropData"> <!--- this is a custom tag
--->

<cfdump var="#rsPropData#">