January 31, 200422 yr 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?
January 31, 200422 yr 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.
Create an account or sign in to comment