How to use FIND() in an IF() statement

hank

I'd like to be able to hide a group within a component based on the value of a text list variable (OPENING!TYPE) users select.

Here is the IF clause I am using for the groups "Hidden" attribute:

=IF(find("SINGLE",OPENING!TYPE),FALSE,TRUE)

Which says "If the string "SINGLE" is found in the attribute value for "OPENING!TYPE", return FALSE making the group not hidden, otherwise return TRUE making the group hidden.

The problem is that FIND() returns a number for where it found the search string. That is fine for when it successfully finds the search string because any positive number evaluates to true. BUT when it does not find it, it returns something like

Not found; SINGLE

Which does not evaluate to FALSE.

So, how can I use FIND() to return TRUE or 1 if it finds the search string and FALSE or 0 when it does not?

Thank you.

Jim

Not tested, but maybe:

=IF(find("SINGLE",OPENING!TYPE)>0,FALSE,TRUE)

pcmoor

find needs to return a value, a position. so if if there is no match it fails. Since there is no error catch procedure, it is not possible to
IF(find("SINGLE",OPENING!TYPE)>0,FALSE,TRUE) unless "SINGLE" exists, can only be true or an error

hank

Well that stinks. Is there any way to test for an error. Will Jim's solution work?

Jim

@hank said:

Well that stinks. Is there any way to test for an error. Will Jim's solution work?

You could use LEFT and EXACT.

=EXACT(LEFT(OPENING!TYPE, 6), "SINGLE")

or a simple IF

=IF(LEFT(OPENING!TYPE, 6) = "SINGLE", TRUE, FALSE)

or maybe even

=IF(OPENING!TYPE = "SINGLE", TRUE, FALSE)

hank

Thank You Jim!

So how about if I wanted to find out if the string "SINGLE" exists anywhere in the string?