topic Re: Can an IF formula use boolean character filtering? in Discussions

Can an IF formula use boolean character filtering?

NathanFisk — Tue, 28 Jan 2025 17:26:22 GMT

Hello all,

I'm trying to run a column creation formula in JMP and I can't figure out how to get the system to perform the function I'm wanting.

Specifically, there is a column of Serial Numbers of six characters. The first character is always an "S" (for serial number). The next 5 characters will always be a sequence of five numbers that begins either with a 7, a 5, or a 0 (representing three different product generations).

What I'd like to do is make a formula that does an "IF" function that says "IF (VAR) = S7* THEN "3"" ... which would look at the serial number column and see if it started with an S7 then it would set the new column's value to 3 (3rd generation) and so on with generation 2 and generation 1.

Is this possible with the JMP formula logic? There's a ton of options but its a bit complicated figuring them all out.

Re: Can an IF formula use boolean character filtering?

jthi — Tue, 28 Jan 2025 17:30:49 GMT

Many options for this, if-elseif most simple one

If(
	Starts With(:col, "S7"), "3"
	, Starts With(:col, "S3"), "1"
	// and so on
);

you can also chain the if-statements if necessary or use IsMissing(Regex()) for more complicated pattern comparisons. If you can provide example data we can provide better examples (add wanted result column if possible).

Re: Can an IF formula use boolean character filtering?

hogi — Tue, 28 Jan 2025 21:18:55 GMT

another option: Match

New Column( "generation",
	Formula( Match( Word( 2, :Column 1, "" ),
"3", 1, 
"5", 2, 
"7", 3 ) )
)

Re: Can an IF formula use boolean character filtering?

NashTaylor — Wed, 29 Jan 2025 13:18:25 GMT

Thank you.