ibiubu Posted February 3, 2005 Share Posted February 3, 2005 If I have a field that contains text, seperated by paragraph returns such as: Apple Orange Banana Pineapple Cherry And I have another empty tect field... Is there a calculation that can be used that if I type any of the words contained in the first field, the calculation would return a positive value. For example, if I type "Orange" in the second text field, the calculation sees that the first field contains the matching word "Orange" and so the calculation returns a value of "Yes" Larry Link to comment Share on other sites More sharing options...
BobWeaver Posted February 3, 2005 Share Posted February 3, 2005 Case(Position(FirstField,SecondField,1,1),"Yes","No") Link to comment Share on other sites More sharing options...
BobWeaver Posted February 3, 2005 Share Posted February 3, 2005 Actually, it's better to use this: Case(Position(" Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted February 3, 2005 Share Posted February 3, 2005 Hi, Could also be done through a relationship from field 2 to field 1 within the same record and an autoentered calc. Oops. FM6 post, so a strict unstored calc wouldn't be as helpfull that the one Bob suggested... Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6625 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