cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
aumair
Level III

Contains function help

Hello, 

 

I am a JMP/JSL rookie. I was just experimenting if I can get th char number of first "a"  in the 'name' column of Big Class.jmp.

 

I am writing this in formula: Contains(:name, "a", 1), and the output is 0 in all the rows. Could someone please point out the problem?:)

 

Thanks!
Ahmad

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Contains function help

Character strings in JMP are case sensitive.  The correct formula is:

contains(:Name,"A")
Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Contains function help

Character strings in JMP are case sensitive.  The correct formula is:

contains(:Name,"A")
Jim
aumair
Level III

Re: Contains function help

Thanks a lot!!!


@txnelson wrote:

Character strings in JMP are case sensitive.  The correct formula is:

contains(:Name,"A")