cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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")