I would like to build a calculated field that recognizes or picks words / texts in a given text area of 644 characters and then assigns values according to the words / text recognized.
Below is what I tried so far. It doesn't work if there are other characters in the field. It doesn't pick the words. Any suggestions?
CASE WHEN [@field:Knowledge]='Support' THEN 300 WHEN [@field:Knowledge]='Department Budget' THEN 450 WHEN [@field:Knowledge]='Strategic and Budget Development' THEN 600 WHEN [@field:Knowledge]='Deal with Board of Directors' THEN 750 ELSE '0' END
Any recommendations are appreciated.