JMP Script: How do I select rows based on variable cell value?

kyawkag — Sat, 10 Jun 2023 23:36:02 GMT

Hi,

I'm trying to write a script to select the rows with either the SerialNo or the Data value of 1-25 (highlighted rows below).

Is there a way to select these cells with variable?

e.g

data table () << select where (:Item == "SerialNo[1-25] ");

Re: JMP Script: How do I select rows based on variable cell value?

jthi — Tue, 24 Aug 2021 10:00:45 GMT

You might be able to use something like this:

dt << Select Where(0 < :Num(Word(2, :Item, "[]")) < 26);

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(5),
	Compress File When Saved(1),
	New Column("Item",
		Character,
		"Nominal",
		Set Values({"SerialNo[1]", "SerialNo[4]", "SerialNo[26]", "Data[2]", "Data[30]"}),
		Set Display Width(75)
	)
);

dt << Select Where(0 < :Num(Word(2, :Item, "[]")) < 26);

topic Re: JMP Script: How do I select rows based on variable cell value? in Discussions

JMP Script: How do I select rows based on variable cell value?

Re: JMP Script: How do I select rows based on variable cell value?