I need to duplicate a field on the same layout. Change the name of the field and still retain the information in the field on each record.
Can anyone instruct me on how to achieve this?
Should the data be in the renamed field or in the new field?
Please tell us more about the table and fields involved and the purpose of this file.
What are the field names, what is the name of the original field, what do you want to name the new field?
It seems highly likely that your request is not the best way to solve the problem.
Any time we see Name1, Name2, Name3; or Sales2010, Sales2011, Sales2012; etc. that's is the wrong way to approach the problem.
I need the data to be in both the original field and the new field. The new field is the one that will be renamed.
My intention is to keep the original information in the original field intact. The information in the duplicate field that will be renamed will change only slightly. So the fields must be independent of each other. I was hoping to be able to get the information into a the new field and remove some information and keep the rest without it affecting the information in the original field.
The original field is called "Full Address" that contains a name and address of a client. The new field will be "Address" that will contain only the street address. I am trying to duplicate the "Full Address" field, remove the name, and be left with just the "Address". I think it will be faster to duplicate the field and just delete the name of each client rather than copy and paste each address.
you can use replace field contents ( address ; your_calculation )
or write a looping script that uses set field..
go to first record
set field ( address ; your_calculation )
go to next record (exit at last)
How is the Full Address field populated? Is it a calc field or a text field?
Does the Full Address field ALWAYS contain a first line that is the name field?
If so, Address could be a calc field:
MiddleValues( Contacts::Full Address; 2; valueCount( Contacts::Full Address))
Note that as written here, the field will include a trailing return. It is possible to remove that.
If you don't want it to be a calc field, then you can use the expression in a Replace Field Contents script step.
The "Full Address" field is a text field.
The first line is always the name.
The "Full Address" field is text field that is always like this:
city, state, zip
I need to get just the address into the new field called "Address"
city, state zip
You could define a field of type calculation that returns all or just part of your full address field data, then you can go back into manage database and redefine it as a text field to get a new text field with all or part of the data from the first field.
Something like this.
Always have a backup file before performing replace operations!
Retrieving data ...