469,347 Members | 17,002 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,347 developers. It's quick & easy.

Find 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
Dec 31 '05 #1
4 1246
"Hank Rouse" <ha*********@hotmail.com> wrote
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
Dec 31 '05 #2
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.
*** Sent via Developersdex http://www.developersdex.com ***
Dec 31 '05 #3
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
"Hank Rouse" <ha*********@hotmail.com> wrote in message
news:MN***************@news.uswest.net...
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.
*** Sent via Developersdex http://www.developersdex.com ***

Dec 31 '05 #4
Hank Rouse wrote:
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


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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Dec 31 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Roy W. Andersen | last post: by
3 posts views Thread by Alois Treindl | last post: by
9 posts views Thread by Hemant Shah | last post: by
4 posts views Thread by destroooooy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.