pmusaev Posted March 9, 2004 Share Posted March 9, 2004 what function would i use to test if a given text string appears in a text field. ie. say i have a field that holds the value "THIS STRING IS TO BE TESTED" and I have a function that calls... If FIELDNAME CONTAINTS "STRING" RETURN POSITIVE. any help would be appreciated. cheers! Link to comment Share on other sites More sharing options...
-Queue- Posted March 9, 2004 Share Posted March 9, 2004 If [PatternCount( " " & field " ", " stringtotest " )] or If [Position( " " & field & " ", " stringtotest ", 0, 1 )] The extra spaces are to ensure that a partial match isn't found, such as looking for 'ask' in a field containing 'task'. Link to comment Share on other sites More sharing options...
pmusaev Posted March 9, 2004 Author Share Posted March 9, 2004 sanks Queue! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7323 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