Formula to truncate text in a field 1

[jfokas]

I need to create a formula that will return all the text in field up to a specific phrase, in this case "Cinincal Summary". Can someone offer some guidance?

Thanks,

 

[vidru]

This should do it. If it doesn't find "Clinical Summary" in the field, it displays the field as is:
[tt]
if InStr({Table.Field}, "Clinical Summary") = 0 then
{Table.Field}
else
Left({Table.Field}, InStr({Table.Field}, "Clinical Summary") - 1);
[/tt]
-dave