2 fields into 1

[damo]

I am redesigning one of my old databases. What was 2 fields on the old database I have now set up as 1 field in the new one. Each record in the old database only has information in 1 of the 2 fields. When I import the old data, I want it to bring in information from both the fields into one. Is there a way I can do this?

[Ted S]

damo,

My first instinct would be to create a new field in your OLD DB that was a combination (calculation) of the two fields and then export/import the contents of only the new field. Maybe something as simple as:

SetField [NewField; OldTable::OldField1 & OldTable::OldField2]

[transpower]

Or you could do it the other way: create another field in the new database and import. Then set the first field in the new db to the other field if it (the second field) is not blank. Then delete the second field. This way you keep the integrity of your previous db.