how to use contains for mutiple charators selection and subset ?

Sean_ShCn0

I wrote a script for the following purpose:

1. for "chart" column, i want select all items which contains mutiple charators like：" Trace width","Trace thickness","insulator thickness" , actually i have more to be selected, but in jsl which i worte just take 3 charators. I take 6 rows to take them one by one, and subset them to 3 new tables. that is a a little complex, any ideas to set only one row script like OR() or ORMZ(), i tried, but failed. the script works, but seems to stupid.-_-!!!
2. second question, in the subset rows, i have set output talbe("TT"), means i want to name the new subset talbe, but actually the new table name is not change, how i can write the script for it ?

Names Default To Here(1);
IM = Open("$DESKTOP/sample table.jmp" );
IM <<select where(contains (:Chart,"Trace thickness"));
dt=IM<<subset(Rows(IMP),selected rows(0),output table ("TT"));

IM <<select where(contains (:Chart,"Trace width"));
dt=IM<<subset(Rows(IMP),selected rows(0),output table ("TW"));

IM <<select where(contains (:Chart,"Insulator thicknes"));
dt=IM<<subset(Rows(IMP),selected rows(0),output table ("InT"));

Data Table( "Subset of sample table" ) << Concatenate(
	Data Table( "Subset of sample table 2" ),
	Data Table( "Subset of sample table 3" ),
	Output Table( "IMP table" )
);

sample table.jmp

jthi

You could use Or and multiple contains statements, Substitute to replace those strings and check for length or use Regex. Here are examples for substitute and regex (substitute is most likely faster)

Names Default To Here(1);

dt = Open("$DOWNLOADS/sample table.jmp");
dt << select where(Length(:Chart) > Length(Substitute(:Chart, {"Trace thickness", "Trace width", "Insulator thicknes"}, {"", "", ""})));
// dt << select where(!Is Missing(Regex(:Chart, "Trace thickness|Trace width|Insulator thicknes")));

dt_subset = dt << Subset(Selected Rows, Selected Columns Only(0), Output Table("Subset"));