topic Re: Can JMP column selection accept asterisk (*)? in Discussions

Can JMP column selection accept asterisk (*)?

OneNorthJMP — Fri, 17 May 2019 02:49:13 GMT

I want to select list of columns with below expression NVM_VMAX_VCMIN_RD_ICB_ECC0*.SB only. But when i type *, JMP cannot recognize it. Is there any idea how to achieve my objective? Thanks

Re: Can JMP column selection accept asterisk (*)?

ian_jmp — Fri, 17 May 2019 08:56:22 GMT

Take a look at the 'Show Filter' option under the red triangle in your screenshot above:

Re: Can JMP column selection accept asterisk (*)?

OneNorthJMP — Fri, 17 May 2019 09:01:52 GMT

Hi Ian,

My case i have list of tests below. But i only want to stack NVM_VMAX_VCMIN_RD_ICB_ECC0_*MB.
I only want *.SB & *.FUNC.

NVM_VMAX_VCMIN_RD_ICB_ECC0_1000.SB
NVM_VMAX_VCMIN_RD_ICB_ECC0_1000.MB
NVM_VMAX_VCMIN_RD_ICB_ECC0_1000.FUNC
NVM_VMAX_VCMIN_RD_ICB_ECC0_2000.SB
NVM_VMAX_VCMIN_RD_ICB_ECC0_2000.MB
NVM_VMAX_VCMIN_RD_ICB_ECC0_2000.FUNC
NVM_VMAX_VCMIN_RD_ICB_ECC0_3000.SB
NVM_VMAX_VCMIN_RD_ICB_ECC0_3000.MB
NVM_VMAX_VCMIN_RD_ICB_ECC0_3000.FUNC

Re: Can JMP column selection accept asterisk (*)?

ian_jmp — Fri, 17 May 2019 11:30:36 GMT

I thought the column filter was more flexible, but perhaps my memory is failing me. You could always select columns with a JSL snippet in this fashion:

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Probe.jmp");
allCols = dt << getColumnNames("String");

myCols = {};
for(c=1, c<=NItems(allCols), c++,
	thisCol = allCols[c];
	if(StartsWith(thisCol, "M") & EndsWith(thisCol, "VGATERTFF"), InsertInto(myCols, thisCol));
);
dt << selectColumns(myCols);

then just hit 'Stack Columns' in the dialog. Not sure if you wanted to use code, though. As usual, the 'best' answer depends on exactly what needs to be done, by whom and how often.

Re: Can JMP column selection accept asterisk (*)?

gzmorgan0 — Mon, 20 May 2019 09:47:29 GMT

@OneNorthJMP , I think @ian_jmp 's solution is the most flexible.

Extending Ian's first suggestion:

Use the red menu to Show Filter
Then use the black menu, to the right of the magnifying glass and select Regular Expression and Ignore Case.
Then type in .\.func|sb that is is period, escape (\), period, func, or (|). sb. The screenshot is shown below. Of course if you wanted the leading name, type this string [nvm_vmax_vcmin_rd_icb_ecco_]?.\.func|sb

The downside to this approach is that it requires knowledge of some basic regular expression syntax.

Re: Can JMP column selection accept asterisk (*)?

ian_jmp — Mon, 20 May 2019 10:23:53 GMT

Thanks @gzmorgan0 - I must have found this before because of my 'more flexible' comment in the thread above. But clearly I wasn't able to find it again!

To be clear, (and on a Mac) clicking on the magnifying glass you get with 'Show filter' will bring up the required context menu . . .

Re: Can JMP column selection accept asterisk (*)?

OneNorthJMP — Mon, 20 May 2019 13:08:56 GMT

Hi gzmorgan0,
That is the solution i am looking for. Regular expression work for me. Thanks.

Thanks to Ian for your support!