Conditional Texts Or Word Recognition And Value Assignments Under Calculated Field

[Elena]

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.

[Jan]

Hello Elena,

As far as I know, there are several special functions for text.

You can use, for example, Charindex

CASE
    WHEN Charindex('Support',[@field:Knowledge])!=0 THEN 300

    WHEN Charindex('Department Budget',[@field:Knowledge])!=0 THEN 450

    WHEN Charindex('Strategic and Budget Development',[@field:Knowledge])!=0 THEN 600

    WHEN Charindex('Deal with Board of Directors',[@field:Knowledge])!=0 THEN 750

   ELSE '0'

END

I hope, it helps.

[Elena]

Hello Jan,

 

Thank you so much as usual. This works fantastically.

I am really impressed by the wealth of informatio here, the support is phenomenal.

Customer service is what sets you guys apart from your competitors. Don't ever change.

 

Elena

[Jan]

Hello Elena,

 

You are welcome   

[alanhoffman]

Perfect.. This is exactly what I was looking for.

 

I 100% endorse Elena's comments - a truly wonderful level of knowledge and support...

[humbabba]

Great stuff. But what if the field you're checking is a checkbox? So a binary, not text, value?