How to delete 1st 2 rows in a csv/excel file?

Sorry It would not let me attach the cfc in the last post for some reason.

Here it is.

<!---
DateCreated: 07/19/2009
Author:         Joseph Snyder
Name:         QueryUtils.cfc
Purpose:     General purpose utilities for manipulating Queries. Currently there is only one method.
--->

<cfcomponent hint="Misc Utilities for manipulating queries, current there is only one function." output="false">

    <cffunction name="removeRecordsByIndex" returntype="Query" output="false" description="I remove records from a query based on index numbers supplied.">
        <cfargument name="queryObject" type="Query" required="true" hint="Query to remove records from" />
        <cfargument name="indexArray" type="Array" required="true" hint="An array of index numbers of the records you want removed." />
       
        <cfscript>
            for(i=1; i < ArrayLen(ARGUMENTS.indexArray); i++){
                if(!IsNumeric(ARGUMENTS.indexArray)){
                    ArrayDeleteAt(ARGUMENTS.indexArray, i);
                    //I should throw an error here but I am being lazy
                }
            }
           
            i=1;
            cl = [];
            cl = ARGUMENTS.queryObject.columnlist;
            newQuery = queryNew(cl);

            While(i <= ARGUMENTS.queryObject.recordcount){
                j=1;
                if(!ArrayFind(ARGUMENTS.indexArray,i)){
                    QueryAddRow(newQuery);
                    While(j <= ListLen(cl)){
                        cn = listGetAt(cl,j);
                        QuerySetCell(newQuery,cn,ARGUMENTS.queryObject[cn]);
                        j=j+1;
                    }
                }
                i=i+1;   
            }
           
            return newQuery;
        </cfscript>
   
    </cffunction>

</cfcomponent>

Here is the same written as a cfc.  The Foo.Bar part is just to show that accidently adding something other then a number should not throw it off.  However I did not test this against other data objects such as complex objects or variables.  but those should cause their own errors which should not be hard to track down.  One would hope.

You would use it as so.

<cfquery name="myQuery" datasource="myDataSource" >
    SELECT *
    FROM myTable
</cfquery>

<cfdump var="#myQuery#" />

<cfscript>
    RecordsToRemove = [1,2,3,"foo.bar",4,5,7,9,22];
    obj = CreateObject("component", "QueryUtils");
    newQuery = obj.removeRecordsByIndex(myQuery,RecordsToRemove);
</cfscript>

<cfdump var="#newQuery#" />

From your question it sounds to me like qCsvData is already a Query Object.

That being the case you could use this script to remove the lines you want to remove.  I pulled this out of one of my CFC's.  You likely would want to add it back into a custom udf or cfc of your own and pass in the query object you want it to run against and an array of row index's you want to have left out of the return query.

For now I just changed where the arguments.query would be with your specified qCsvData queary object so it would be easier for you to test and threw in some rowsToIgnore.  Just change it to [1,2] if you only want those rows left out but note that you can ignore any row by index.  You also do not need to know what the column names are for this to work.

<cfdump var="#qCsvData#" />

<cfscript>
    rowsToIgnore = [1,2,3,4,5,7,9];

    i=1;
    cl = [];
    cl = qCsvData.columnlist;
    newQuery = queryNew(cl);
    While(i <= qCsvData.recordcount){
        j=1;
        if(!ArrayFind(rowsToIgnore,i)){
            QueryAddRow(newQuery);
            While(j <= ListLen(cl)){
                cn = listGetAt(cl,j);
                QuerySetCell(newQuery,cn,qCsvData[cn]);
                j=j+1;
            }
        }
        i=i+1;   
    }
</cfscript>

<cfdump var="#newQuery#" />

NOTE:  There is very likely a much better way of doing this but this is what I had handy for you.

Hope you like it!

-Joe

Any ideas?