pmusaev Posted January 31, 2004 Share Posted January 31, 2004 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? Link to comment Share on other sites More sharing options...
RodinBangkok Posted January 31, 2004 Share Posted January 31, 2004 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7391 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now