ListRest() should work.
OR a simple counter in your loop to exclued the first line or two or three from being inserted into your database.
<cfset counter = 1>
<cfif counter GT 3>
<cfset counter = counter + 1>
Thank you guyzzz
Hope this idea isn't too late for you...
You could setup a CSV ODBC datasource, and then connect to that in the datasources part.
You'll have to tell it the separators, but you can easily setup a datasource per type to make it easier.
As long as you know the folder that the files will be located, you can run the query like this:
<cfquery name="CSV_data" datasource="CSV_test">
It should be easier on the memory than trying to treat it as a list, and faster too for larger files.
Thank u. I am not using cfchart ...anymore
* confused look *
Sorry... I mean Thank you all for support and advice..
I realised afterwards that you had another thread about cfchart, so you might have confused the threads and posted on the wrong one - just seemed a little strange that you was talking about cfchart on a CSV question
Yes i know... was so busy doing lots of things