Tom England Posted December 5, 2001 Share Posted December 5, 2001 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 Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted December 5, 2001 Share Posted December 5, 2001 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 Link to comment Share on other sites More sharing options...
elvis_impersonating_penguin Posted December 5, 2001 Share Posted December 5, 2001 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 More sharing options...
Recommended Posts
This topic is 8150 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