Can an IF formula use boolean character filtering?
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 dif...