topic Re: delete specefic row in column in Discussions

delete specefic row in column

NetflixCrow956 — Fri, 09 Jun 2023 16:55:55 GMT

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

Thank you

Re: delete specefic row in column

txnelson — Mon, 04 Apr 2022 13:20:45 GMT

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

jthi — Mon, 04 Apr 2022 14:30:15 GMT

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

Re: delete specefic row in column

Byron_JMP — Mon, 04 Apr 2022 18:20:07 GMT

If you didn't want to use JSL to solve the problem, then a formula column could help.

Similar to @txnelson solution, make a new column, and paste this formula into it.

Left( :Order Number, 5 )

Then in your data table, click on the one row that has 00097 to select it, then use the right click option to Select Matching Rows.

Once they are selected you can either delete those rows, or right click to Exclude/Hide them, so that you preserve all of your original data.

Re: delete specefic row in column

NetflixCrow956 — Tue, 05 Apr 2022 05:23:37 GMT

Thank you so much

Re: delete specefic row in column

NetflixCrow956 — Tue, 05 Apr 2022 05:23:56 GMT

Thank you !

Re: delete specefic row in column

NetflixCrow956 — Tue, 05 Apr 2022 05:24:38 GMT

Thank you !