Newbies bspoll Posted February 19, 2001 Newbies 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
Ocean West Posted February 19, 2001 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).]
Newbies bspoll Posted February 19, 2001 Author Newbies 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....
john.daly Posted February 19, 2001 Posted February 19, 2001 Make sure all your fields are text fields and not numbers.
Newbies bspoll Posted February 19, 2001 Author Newbies 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.
john.daly Posted February 20, 2001 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?
Newbies bspoll Posted February 28, 2001 Author Newbies Posted February 28, 2001 Thanks Guys, sorrythis took so long-I got stuck doing another project.
Recommended Posts
This topic is 8669 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