tallboy755 Posted October 21, 2003 Share Posted October 21, 2003 Hello All Again I have another question ... I know there must be a simple answer to this however it has been a long day and I am having a brain fart. Ok I have an IF Calc ... If( FieldA = "override" , 0, "") Now if the fields A = "override" I get a 0. Well I need it to give me a 0 if the field CONTAINS the word "override" like if I type the word override in a sentence in that field I want a 0. I know I could do this by creating a pattern count on the field for the word override ... however i would like to do this without going to all that trouble. Link to comment Share on other sites More sharing options...
BobWeaver Posted October 21, 2003 Share Posted October 21, 2003 If (PatternCount(FieldA,"override"),0,"") Link to comment Share on other sites More sharing options...
tallboy755 Posted October 21, 2003 Author Share Posted October 21, 2003 Thanks again FMForums ... and all users (say a prayer for me ... I seem to be forgetting simple basics of writing a calculation ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7673 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