Jump to content
  • 0

Conditional Texts Or Word Recognition And Value Assignments Under Calculated Field


Elena
 Share

Question

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.

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...