475779_en-US

liliconcom

delete specefic row in column

 

I would like to delete the lines starting with "00097" how to do?

Thank you

 

 

ScriptingRe: delete specefic row in column

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

Re: delete specefic row in column

Here is one more option using get rows where() in combination with starts with() to get rows into a matrix and then deleting them with delete rows().

 

Script below will remove all names which start with "J" in Big Class datatable:

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