475779_zh-CN

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);
);