Re: Find and Replace against set of rules in 2nd table

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" <hank_top_sf@xxxxxxxxxxx> wrote in message
news:MNptf.51$rc1.6006@xxxxxxxxxxxxxxxxxx
> 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 ***


.

Relevant Pages
Loading