Search the Community
Showing results for tags 'TextsWord Recognition'.
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.