Replacing data from one file with data from another file

[stobin]

I have two files that contain old addresses and want to replace them with the new addresses from the second file. Does anyone know if this is possible to achieve? Your help is appreciated. Thank you.

[Mofi]

There are already several scripts and macros for such a task, see for example

Multiple find and replace from a data file
Scripts to greatly increase a block and replace a placeholder with words listed in another file
How to Perform a Find & Replace via Macro using a source file
How to replace a word with a different set of words
Delete lines in the active document containing strings listed in another file
macro involving captured data from other files
Insert from separate file

All of those macros and scripts use more or less the same technique, but differ a little depending on input data file and what exactly should be replaced in the other file.

[stobin]

Mofi, Hi, I am not sure this is exactly what I need. The exact scenario is that that these two files have multiple fields. The ones I am interest in are the account number and the address fields. What I need to be able to do is say, for example:

if the account number in file one, is also in file two, then replace the address for the account in file one with the address from file two. Is this possible?
Thanks,

[Mofi]

Is this possible?

Yes, it is. The easiest method is using a script (or macro) to run a tagged regular expression Replace on account data base file for every data listed in the file with the new address data.

But without exact data snippets best posted within BBCode tags [code]...[/code] showing

• what the accounts data base file contains before script execution
• what the file with the new address data contains before script execution
• what the accounts data base file should contain after script execution based on example data

it is impossible for us to adapt one of the scripts to your requirements and post its code here so that you can simply use it to do the job.