text contains... ?

[pmusaev]

How do I write a function to test the first dozen letters of a string?

Eg.

string = "01-01-001 Cheese Grader" (field name is JOB)

What I need is a function that will test to see... If JOB contains the string "01-01-001".

Does this even make sense?

[RodinBangkok]

Eg- use the pattern count function in a calculated field something like this:

FieldName; StringFoundflag: PatternCount(Job, "01-01-001")

Then do a search for field stringfoundflag greater than 0.

To make it easier to change the find string define a global text field to hold the text and put its name in the place of the "01-01-001", this way you can vary the find criteria easily.