Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8669 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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

Posted

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
Posted

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....

  • Newbies
Posted

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.

Posted

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?

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.