AnsweredAssumed Answered

need help with Case

Question asked by denno on Oct 4, 2013
Latest reply on Oct 4, 2013 by philmodjunk


need help with Case


     I have a field named Diagnosis that contains free text. example: Other closed fractures of distal end of radius (alone);  Scaphoid fracture of wrist

     I am trying to create a field named Body Area that contains text based on what's entered in Diagnosis (e.g., if diagnosis contains "wrist", Body Area would display "wrist".)


     I tried testing it out with Case ( DIAGNOSIS = "*wrist*" ; "wrist" ; DIAGNOSIS = "*hand*"  or "*finger*"; "hand"; "" ) but it's not doing anything. I tried with and without the wildcard operators. 


     Thanks for any help-