Jump to content
Sign in to follow this  
Tom England

Find on any field

Recommended Posts

Can anyone tell me if it is possible to do a find so that it will locate a particulate word / name in any record and field?

ie in excel if you do a find eg. Smith, it will locate Smith in any column and any row.

Thanks in advance

Share this post


Link to post
Share on other sites

quote:

Originally posted by Tom England:

Can anyone tell me if it is possible to do a find so that it will locate a particulate word / name in any record and field?

ie in excel if you do a find eg. Smith, it will locate Smith in any column and any row.

Thanks in advance

I really do not recommend this, but you could construct a calculated field that concatenates the values in the other fields. Don't use any unindexed field in that calculation, because it will be slow enough as it is. There is a limit of 64,000 characters in that text field. There may be other ways to do this, and if I think of them, I'll post back.

HTH

Old Advance Man

Share this post


Link to post
Share on other sites

well another solution, no better than Old Advanced Man's though. you could script a find so that they enter the criteria into a global field and then a script copies the criteria into every field you want to search on (you will have to create a new request for each field i beleive) and then run the find. probably going to be a slow script to run though. I would recomend using the Freeze Window script step before you start creating the the requests and copying the field, it will make it move a little faster. I can't help but think that there has to be a better way though.

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.