Subscribe Bookmark RSS Feed

Contains function help

aumair

Occasional Contributor

Joined:

Feb 9, 2017

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

Joined:

Jun 22, 2012

Solution

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

contains(:Name,"A")
Jim
2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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

contains(:Name,"A")
Jim
aumair

Occasional Contributor

Joined:

Feb 9, 2017

Thanks a lot!!!


txnelson wrote:

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

contains(:Name,"A")