Way to calculate "contains"?

[Steve G]

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?

[aldipalo]

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.

[David Jondreau]

Check out the function called PatternCount().

[alwynus de winslow]

Pattern Count - Excellent suggestion. Thanks!