Jump to content
Sign in to follow this  
bspoll

finding field contains

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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