475779_zh-TW

liliconcom

刪除列中的特定行

 

我想刪除以“00097”開頭的行怎麼辦？

謝謝

 

 

腳本回复：刪除列中的特定行

Names Default To Here( 1 );
dt = Current Data Table();

// Select the rows that meet the qualification
dt << select where( Left( :Order Number, 5 ) == "00097" );

// delete the selected rows.  Using the Try() function keeps
// the deletion from failing if no rows were selected
Try( dt << delete rows );

回复：刪除列中的特定行

這是另一個選項，使用 get rows where() 與 starts with() 組合將行放入矩陣，然後使用 delete rows() 刪除它們。

 

下面的腳本將刪除 Big Class 數據表中所有以“J”開頭的名稱：

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
rows_to_delete = dt << Get Rows Where(Starts With(:name, "J"));
If(N Items(rows_to_delete),
 dt << Delete Rows(rows_to_delete);
 show(rows_to_delete);
);