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, not too long ago... (least using stringBuff?) May the import force be with you! ;)en On 8/29/06, Jeff Vaught <[EMAIL PROTECTED]> wrote: > > 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 append this ListFix function within your > code? I have downloaded the function and am calling it, but do not know how > to insert it on top of a #listgetat# function. > > Here is my code: > > <cfinclude template="ListFix.cfm"> > > <!--- get and read the CSV-TXT file ---> > <cffile action="read" file="csvdemo.txt" variable="csvfile"> > > <!--- loop through the CSV-TXT file on line breaks and insert into > database ---> > <cfloop index="index" list="#csvfile#" delimiters="#chr(10)##chr(13)#"> > <cfquery name="importcsv" datasource="#database#" username="#dbid#" > password="#dbpass#"> > INSERT INTO csvdemo > (COLOR, > SIZE, > INSTOCK, > STYLE) > VALUES > ('#listgetAt('#index#',1, chr(9))#', > '#listgetAt('#index#',2, chr(9))#', > '#listgetAt('#index#',3, chr(9))#', > '#listgetAt('#index#',4, chr(9))#' > ) > </cfquery> > </cfloop> > > <!--- use a simple database query to check the results of the import - > dumping query to screen ---> > <cfquery name="rscsvdemo" datasource="#database#" username="#dbid#" > password="#dbpass#"> > SELECT * FROM csvdemo > </cfquery> > <cfdump var="#rscsvdemo#"> > > > I have tried multiple tests such as throwing the #listfix# function in > front of the #listgetat# like this: > > '#listfix(listgetAt('#index#',4, chr(9)))#' > > but it doesn't work. Please advise. > > Also, kinda unrelated to the listfix function, I heard you could use > ISNULL function as seen here: > > http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20546746.html > > but I cannot get it to work either with my code. I've used it like so: > > 'ISNULL(#listgetAt('#index#',4, chr(9))#,'')' > > Any and all help would be greatly appreciated. > > > Mark this message as the answer. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
