Support 805.461.7300
Sales
Our Technology. Your Success.

Copy a field from one list to another when records match

SET SAFETY OFF
SELECT("databaseWithInfo")
INDEX ON ALLT(UPPER(address))+ALLT(zip) TAG mytag
SELECT("databaseWithMissingInfo")
REPLACE all phone with databaseWithInfo.phone1,email with databaseWithInfo.email for SEEK(ALLT(UPPER(address))+ALLT(zip),"databaseWithInfo")

In the above command, I compared two databases, and when there were matches based on the address and zip fields, I took the information from the phone1 field in one database and copied it into the other database's phone field. I did the same with the email fields in the two databases.

DatabaseWithInfo is the database that originally contained the phone1 and email information. I wanted to take that information and put it into the fields named phone and email of the database named databaseWithMissingInfo.

The index line (the third line of the command) specifies which fields I want to compare between the two databases. That index is referenced again in the last line of the command, within the SEEK( ) function. The database that you're filling information with will only be referenced once in the command.

« Back to Commands

All of you at Accuzip are TOP NOTCH in customer service! I've been mailing for 25 years and I only wish I'd found Accuzip years ago! You are all wonderful. Thanks for being there for me!
L.B., Englewood, FL