filter - Spotfire: Can you write a case statement based on a column containing a substring -

i want create calculated column based on substring. can't find syntax following

 case   when [projectname] contains "substring" [value]  end 

for example, when [projectname] contains "overhead" "overhead" [projectname] equal "project 1 overhead", "project 2 billable", or that.

the easiest solution use find() if() or case() statement.

if(find("overhead",lower([projectname])) >0,[value],"false")  case      when find("overhead",lower([projectname])) >0 [value] end 

just remember, find() case sensitive.

if step in replacing sub-string value, want use rxreplace()