cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

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