Ray's solution will work. Or, at least, it's worked for me in the past. <cfhttp URL="http://...file.txt" name="myquery" delimiter="#chr(9)#" textqualifier="">
On 3/23/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > Have you tried using Chr(009) instead of the comma? > > Christophe Maso wrote: > > If I have a tab-delimited text file I want to make into a query object > > using cfhttp, how should I enter the value for the delimiter attribute in > > the cfhttp tag? The O'Reilly book demonstrates how to write it for > > comma-delimited: > > > > <cfhttp URL="http://...file.txt" name="myquery" delimiter="," > > textqualifier=""> > > > > But not for tab-delimited. > > > > Also, if each row in the file ends with carriage return, do I need to use a > > special value for the textqualifier attribute? > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236067 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54