Choose Language Hide Translation Bar
Highlighted
OneNorthJMP
Level IV

Can JMP column selection accept asterisk (*)?

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 

 

JMP_filter.pngJMP_asterick.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
gzmorgan0
Super User

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

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

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

View solution in original post

6 REPLIES 6
Highlighted
ian_jmp
Staff

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

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

Highlighted
OneNorthJMP
Level IV

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

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
Highlighted
ian_jmp
Staff

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

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.

Highlighted
gzmorgan0
Super User

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

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

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

View solution in original post

Highlighted
ian_jmp
Staff

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

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

 

Screen Shot 2019-05-20 at 11.17.53.png

Highlighted
OneNorthJMP
Level IV

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

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

Thanks to Ian for your support!
Article Labels

    There are no labels assigned to this post.