>> I need to get rid of the column headers in the first line, >> and then get rid of any linefeeds after the last piece of data. >> This seemed fairly straightforward when I started... > >...and it should still be fairly straightforward: > ><cfset data = listRest(data, chr(10)) /> ><cfset data = trim(data) />
As pre-parsing the file already, you might as well keep it all in CF. However, you could also skip the header in your LOAD DATA statement using IGNORE x LINES; http://dev.mysql.com/doc/refman/5.0/en/load-data.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
