Newbies bspoll Posted February 19, 2001 Newbies Share Posted February 19, 2001 is there a way to do a find field contains? Example: I want to do find all records that the part number contains "573" and the found set will show: 12573 343573 88757355 Link to comment Share on other sites More sharing options...
Ocean West Posted February 19, 2001 Share Posted February 19, 2001 Try this... Part_Number: Part Number gField: A global you are searching for cField: Calculation to find Result. code: PatternCount(Part_Number, gField) then perform search on cField for anything >0 [This message has been edited by Ocean West (edited February 19, 2001).] Link to comment Share on other sites More sharing options...
Newbies bspoll Posted February 19, 2001 Author Newbies Share Posted February 19, 2001 This does not seem to work, does it matter if product number contains both numbers and letters (sk45170), would like to be able to search 45170 and get sk45170 and sk45170-2 etc.... Link to comment Share on other sites More sharing options...
john.daly Posted February 19, 2001 Share Posted February 19, 2001 Make sure all your fields are text fields and not numbers. Link to comment Share on other sites More sharing options...
Newbies bspoll Posted February 19, 2001 Author Newbies Share Posted February 19, 2001 all fields are text except for pricing and a picture container. can search sk45170 but not all of my customers relize that they need the sk first, also not all part numbers have "sk" there is also other vendor codes in front of number. Link to comment Share on other sites More sharing options...
BobWeaver Posted February 20, 2001 Share Posted February 20, 2001 cField should be number, not text. Link to comment Share on other sites More sharing options...
john.daly Posted February 20, 2001 Share Posted February 20, 2001 Yes, I agree that cfield ought to be Number (although it works if it is text!). I set up the solutin as described using the data given and it certainly worked for me. Are you still having problems with it? Link to comment Share on other sites More sharing options...
Newbies bspoll Posted February 28, 2001 Author Newbies Share Posted February 28, 2001 Thanks Guys, sorrythis took so long-I got stuck doing another project. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8450 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