 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / December 2005Find and Replace against set of rules in 2nd table
Looking for a tool, or code that does the following. Edit [partial field data] in TBL1, if [partial field data] meets criteria in TBL2, COL1. TBL2, COL2 has the REPLACE WITH information. Not sure if this edited data can be written directly to the TBL1, or needs to write to a TEMP TBL. As I will continue to be tweaking and TBL COL1 & COL2, I would like this to be a query so that I can run it as needed. Thanks in Advance > Looking for a tool, or code that does the following. Unlikely there's a "tool" that meets your specific requirements. It's quite possible that code or a query could be developed to do it -- depending on the details. > Edit [partial field data] in TBL1, if [partial field data] meets criteria in > TBL2, COL1. TBL2, COL2 has the REPLACE WITH information. Can you be specific about "meets the criteria" in TBL2, COL1? And, er, what do you mean by "[partial field data]"? > Not sure if this edited data can be written directly to the TBL1, or needs > to write to a TEMP TBL. Are TBL1 and TBL2 related by a key/foreign key, or do you intend that TBL2 is a table of instructions for updating each Record of TBL1? > As I will continue to be tweaking and TBL COL1 & COL2, I would like this to > be a query so that I can run it as needed. Larry Linson Microsoft Access MVP No Primary or Foreign key is in place at this time, as the data needs to go through a couple of 'scrubbers' first. This scrubber is the one that will determine other features down the road. "[partial field data]" is just that, I am not replacing the contents of the entire cell or field. I am only replacing part of the text, based on the Find/Replace criteria/rules in TBL2. TBL1 COL1 Mari Johnson Jim Evans Charles Stanley Jerry Straight TBL2 COL1 COL2 Mari Mary Straight Strait See, I'm simply searching TBL1, COL1 for any match in TBL2, COL1. If a match is found, Bad data in TBL1, COL1 is replaced by TBL2, COL2 > No Primary or Foreign key is in place at this time, as the data needs to > go through a couple of 'scrubbers' first. This scrubber is the one that [quoted text clipped - 5 lines] > > *** Sent via Developersdex http://www.developersdex.com *** > TBL1 > [quoted text clipped - 12 lines] > See, I'm simply searching TBL1, COL1 for any match in TBL2, COL1. > If a match is found, Bad data in TBL1, COL1 is replaced by TBL2, COL2 How would any code or query possibly know that Mari is a "bad" version of Mary and not simply a different person entirely? You would have to have a primary key field that agrees between the two tables.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.