Formula & Specific Text

[tommcbrny]

Hello,

I saw a thread indicating that there are no wildcard values for formulas, so
that may be my answer. Here's the question though:

Can I create an IIF formula to be true if a field contains text "xyz"
anywhere in the field? For instance, I want a formula to be true if the task
name field contains the text "Training", but false otherwise.

A sample task name that should return a value is "FSA Training and Exams".

Is this possible?

Thanks,
Tom

 

[Gérard Ducouret]

Tom,
Use the InStr function :
IIf(InStr([Nom];"Training")>0;True;False)

Gérard Ducouret

 

[Gérard Ducouret]

;-)
In English the formula would be :
IIf(InStr([Name];"Training")>0;True;False)

Gérard Ducouret

Tom,
Use the InStr function :
IIf(InStr([Nom];"Training")>0;True;False)

Gérard Ducouret

"tommcbrny" <[email protected]> a écrit dans le message de

Hello,

I saw a thread indicating that there are no wildcard values for

formulas,

so
that may be my answer. Here's the question though:

Can I create an IIF formula to be true if a field contains text "xyz"
anywhere in the field? For instance, I want a formula to be true if the task
name field contains the text "Training", but false otherwise.

A sample task name that should return a value is "FSA Training and Exams".

Is this possible?

Thanks,
Tom

 

[tommcbrny]

Hi Gerard,

Thanks very much, the formula works great now. I had to change the
semi-colons to commas, but once I did that it worked out great.

Regards,

Tom

;-)
In English the formula would be :
IIf(InStr([Name];"Training")>0;True;False)

Gérard Ducouret

Tom,
Use the InStr function :
IIf(InStr([Nom];"Training")>0;True;False)

Gérard Ducouret

"tommcbrny" <[email protected]> a écrit dans le message de

Hello,

I saw a thread indicating that there are no wildcard values for

formulas,

so
that may be my answer. Here's the question though:

Can I create an IIF formula to be true if a field contains text "xyz"
anywhere in the field? For instance, I want a formula to be true if the task
name field contains the text "Training", but false otherwise.

A sample task name that should return a value is "FSA Training and Exams".

Is this possible?

Thanks,
Tom