[jas.]

We have a few old attribute descriptions that I'm needing to include on a report that have bits and pieces of annoying text in them from a very old coding system. For instance:

Category: Former Commitee
Description: Major Gifts Committee (Former)


I'm doing a report and I just want to remove the parenthetical piece. I know I could do a code like

if {field} = "Major Gifts Committee (Former)" then "Major Gifts Committee"

and do a bunch of else ifs depending on what all's in there. It's a relatively small report, so that's doable. But is there a way to just have it suppress that string in the field?

I suspect not. But I figured it would be worth it to see if you guys knew...

[DrewAllen]

You can use the Replace() function to replace one string "(Former)" with another "" in an input string {field}. This would be reasonable if there is a very small set of such substitutions.

Drew

[jas.]

oh, yeah, that would obviously do the trick. Thanks!

[DrewAllen]

Another option if the parenthetical string always appears as the last element in the string is to use the CharIndex() to find the first occurrence of the character "(" and Left() to pull everything up to that value.

Drew

[DrewAllen]

Sorry, CharIndex() is a SQL function. In Crystal you would use InStr().

Drew