delete rows w/o creating new file
Hello Everyone, I m wondering if there is any way to delete first few rows in csv file without parsing the entire file and then creating a new file. My csv file is huge. To remove the first few rows(which contains header) only, I do: cfloop get each row from source file store/append it in destination file /cfloop Any help will be greatly appreciated. Thank you so much. ~| 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:311414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
delete rows w/o creating new file
Hello Everyone, I m wondering if there is any way to delete first few rows in csv file without parsing the entire file and then creating a new file. My csv file is huge. To remove the first few rows(which contains header) only, I do: cfloop get each row from source file store/append it in destination file /cfloop Any help will be greatly appreciated. Thank you so much. ~| 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:311415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: delete rows w/o creating new file
Are you taking and uploading the .csv file? If so, you could leave the header info and just ignore the first few lines (if it's static). On Fri, Aug 22, 2008 at 11:01 AM, MJ R [EMAIL PROTECTED] wrote: Hello Everyone, I m wondering if there is any way to delete first few rows in csv file without parsing the entire file and then creating a new file. My csv file is huge. To remove the first few rows(which contains header) only, I do: cfloop get each row from source file store/append it in destination file /cfloop Any help will be greatly appreciated. Thank you so much. ~| 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:311416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: delete rows w/o creating new file
cfloop get each row from source file cfif currentrow neq 1 store/append it in destination file /cfif /cfloop ? The obligatory you can probably use a database-specific tool or feature to do this a *whole lot faster* is required. -- I was a veteran, before I was a teenager. Michael Jackson On Fri, Aug 22, 2008 at 10:00 AM, MJ R wrote: Hello Everyone, I m wondering if there is any way to delete first few rows in csv file without parsing the entire file and then creating a new file. My csv file is huge. To remove the first few rows(which contains header) only, I do: cfloop get each row from source file store/append it in destination file /cfloop Any help will be greatly appreciated. Thank you so much. ~| 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:311418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4