topic Re: Contains function help in Discussions

Contains function help

aumair — Fri, 05 May 2017 01:24:05 GMT

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

txnelson — Fri, 05 May 2017 03:33:28 GMT

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

contains(:Name,"A")

aumair — Fri, 05 May 2017 05:51:46 GMT

Thanks a lot!!!

@txnelson wrote:
Character strings in JMP are case sensitive. The correct formula is:
contains(:Name,"A")