Jump to content

Find on any field

Tom England

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

Recommended Posts


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.


Old Advance Man

Link to comment
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.

Link to comment
Share on other sites

This topic is 7509 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.