nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can JMP column selection accept asterisk (*)?

OneNorthJMP

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

Accepted answers

gzmorgan0

@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.

All comments

ian_jmp

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

Screen Shot 2019-05-17 at 09.54.03.png

OneNorthJMP

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

ian_jmp

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.

gzmorgan0

@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.