Moving content from one field to another
Hey Filemaker gurus! I Recently did an import into our client database and realized that we imported the clients zip code into our "Postal Code" field (a field we don't really use anymore). So I have a thousand or so records who have their zip code in field "Postal Code" and I need to move it to the field "Zip Code".
Is there an easy (batch) way to do this?
Use Replace Field Contents to copy the contents of Postal Code into the Zip Code field
Save a back up of your DB file in case you make a mistake.
Do a show all records or perform a find to pull up the records where you need this update as this tool modifies all records in your current found set
Click into the zipcode field.
Select Replace Field contents from the Records menu (NOT the edit menu) and use the calculation option to specify the postal code field as the source of the data you want to copy into the zip code field.
Brilliant Phil!
And just to confirm, if I want to search for all records with a Postal Code but not a Zip Code I would search for;
Postal Code = "*" (to show not empty) and Zip Code = "=" (to show empty)
Does that sound right?
That's correct.
Thank you Phil! You're always the best and fastest to answer!
Use Replace Field Contents to copy the contents of Postal Code into the Zip Code field
Save a back up of your DB file in case you make a mistake.
Do a show all records or perform a find to pull up the records where you need this update as this tool modifies all records in your current found set
Click into the zipcode field.
Select Replace Field contents from the Records menu (NOT the edit menu) and use the calculation option to specify the postal code field as the source of the data you want to copy into the zip code field.