AnsweredAssumed Answered

Substitute Calculation "Contains" vs "Equals"

Question asked by lindseym on Dec 29, 2016
Latest reply on Dec 30, 2016 by lindseym

Howdy Folks:


Working on calculation and I ran across this issue. I can't seem to figure out how to do a  Case + substitute calculation when my test does not = something specific.


Here is what I have:


Screen Shot 2016-12-29 at 3.28.38 PM.png






${Copy (Side A)} ? "LEVEL#" ; Substitute ( ${Copy (Side A)} ; "LEVEL#" ; Level from Space ) ;


What I am looking for is:


${Copy (Side A)} contains but does not equal  "LEVEL#" (performed in the first test of case) it performs the substitution. I have the substitute calculation working fine, just not sure how to do an operator of "contains" within a case calculation.





I realized that I could just use ≠ .... but because the case function goes down the list until it evaluates true it would stop at that test. I want it continue down the list if "LEVEL#" isn't contained in the field.


Any thought on the best way to do this?






Working on FMP 14.0.6