Re: Handling empty values in tab delimited file.

Well, with cfhttp, you just put the csv file somewhere web-accessible, and then use the "name" attribute for cfhttp: http://www.your.domain/path/to/csv.file";> The livedoc page has some examples. There is a func at: http://www.cflib.org/udf.cfm?id=1236 that will convert strings to queries, I th

Re: Handling empty values in tab delimited file.

Denny, I'm open to any and all suggestions that "work". I believe I've seen something about using both cfhttp, but haven't looked into it much. Also, if there is a UDF that would be good too. I suppose I should preface by saying that I do not have ANY control over CFADMINISTRATOR, so

Re: Handling empty values in tab delimited file.

Well, it's not what you asked, but have you tried using cfhttp to import that CSV file as a query? Sometimes it's easier, if the cvs is well formatted. Also, there is a UDF out there for importing CSV files, which I assume handles empty elements. I think someone posted some java to do this too,

Handling empty values in tab delimited file.

Developers, In regards to the same question asked by rowbeast here: http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21742253.html?qid=21742253 , the accepted answer states to use the ListFix function from: http://www.cflib.org/library.cfm?ID=1 . My question is, where do you ap