In a given text field, is there a way to calculate the expression "if the field contains" (and similarly, "does not contain")?

IOW, if I had five name records:

John Smith

Mary Jones

John White

Peter Johnson

Jill Jackson

I want a calculated text field to generate a result based on whether (or not) the name record contains the word "john" (which would include John Smith, John White, and Peter Johnson).

Is there a way to do it?

The question is do you want this hard coded into your script or do you want the user to enter the data the field contains?

Hard Coded:

Enter Find Mode()

Set Field(yourfield;"John")

Perform Find()

User Enters:

create a global field g_yourfield

Show Custom Dialog(Enter data;G_yourfield[button; OK;Cancel])

If (get(LastMessageChoice)=2)

Exit Script

EndIf

Enter Find Mode()

Set Field(yourfield;g_yourfield)

Perform Find()

hth

**** My scripts almost always need some tweaking and I have not tried this in real time, but, the concept is there.

Check out the function called PatternCount().

Pattern Count - Excellent suggestion. Thanks!