Tom England 0 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 Quote Share this post Link to post Share on other sites
Steven H. Blackwell 107 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 advanceI 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.HTHOld Advance Man Quote Share this post Link to post Share on other sites
elvis_impersonating_penguin 0 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. Quote Share this post Link to post Share on other sites