IF statement to check last word in field

[ibiubu]

Is there a variation on the IF statement that can be used to check for a match for the last word in a field?

LR

[-Queue-]

Do you mean something like Case( RightWords( fieldname, 1 ) = "this", ... ) ?

[EddyB]

Hi

If this is for use in a calculation field, try this,

Case( RightWords( YourField, 1 ) = "WordToCheck", "Yes", "No")

If it is for use in a script, then,

IF["RightWords( YourField, 1 ) = "WordToCheck""]

Whatever you want if true...

ELSE

Whatever you want if false

END IF

Ed.

Sorry Queue, you beat me to it!

[Razumovsky]

Case(rightwords(YourTestField,1)=YourMatchField, YourDesiredResultIfPositive, YourDesiredResultIfNegative)

-Raz

ed:

Third fastest fingers in the west...

[kenneth2k1]

You mean East

Of course, you are west relative to Eddy!

[EddyB]

Think I better get the old Meavis Beacon Teaches Typing Program out!

[ibiubu]

The ones above worked out great. I in fact had a combined calc that this solved all the problems.

Case(rightwords(Field,1)=MatchField, ResultPositive,

leftwords(Field,1)=MatchField, ResultPositive,

ResultNegative)

LR

[-Queue-]

Or Case( RightWords( Field, 1 ) = MatchField or LeftWords( Field, 1 ) = MatchField, ResultPositive, ResultNegative) for short...