title: Spotfire: Can you write a case statement based on a column containing a substring
body: <p>I want to create a calculated column based on a substring. I can't find the syntax to do something like the following</p>
  
  <pre><code> case 
   when [ProjectName] contains "substring" then [Value]
   end
  </code></pre>
  
  <p>For example, when the [ProjectName] contains "overhead" then "overhead"
  [ProjectName] would be equal to "Project 1 Overhead", "Project 2 billable", or something like that.</p>