cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Dennisbur
Level IV

Match case ( 0 )

Hello

I would like to find test names that continue "pcie0" sometimes in lower or upper format

I understand I should use Match case ( 0 )

I have added it to my script but received error

can you check what I should change in my script? 

 

Column(dt, "PARAMETR") << Set Each Value( If( Contains(( :TEST_NAME,"pcie0")), Match case( 0 ),"PCIE0",:PARAMETR));

Dennisbur_0-1698076264441.png

 

4 REPLIES 4
jthi
Super User

Re: Match case ( 0 )

I'm not sure where Match Case is used outside of Filter Col Selector. You could convert your :TEST_NAME to upper or lowercase using Lowercase() or Uppercase()

Contains(Lowercase(:TEST_NAME), "pcie0")
-Jarmo
Dennisbur
Level IV

Re: Match case ( 0 )

OK, thank you

there are any options to use like a mix for upper or lowercase because I have a mix format text in this column?

jthi
Super User

Re: Match case ( 0 )

I'm not 100% sure what you are trying to do here. You can do the comparison with Regex if you cannot use lowercase()/uppercase() or use two conditions

-Jarmo
hogi
Level XIII

Re: Match case ( 0 )

Column(dt, "PARAMETR") << Set Each Value( If( Contains( :TEST_NAME,"pcie0", Match case( 0 )),"PCIE0",:PARAMETR));
?

no:

hogi_0-1698076850540.png

 

Recommended Articles