Select and Delete Last 2-3 rows via scripting

Peter_Hersh

We have a customer who is importing data from Excel.  The tables come with three rows of text that is not part of the data.  These extra rows are at the bottom of the data table.  The data tables contain different amounts of rows, but all have the same three rows at the end.  They have to import 20+ tables daily, so they would love to automate this process if possible.  Is there a way via scripting to select the last 3 rows in a data table?

Thanks,

DonMcCormack

For 1 table (assuming it's the last selected) :

Current Data Table() << Delete Rows((N Row()-2)::N Row())

If there were lots of tables open, you could loop over them. Start by making sure no other tables are open, then run:

For(i=1,i<=N Table(),i++,

     Data Table(i) << Delete Rows((N Row(Data Table(i))-2)::N Row(Data Table(i)))

)