Script to move text from one field to another?
I need a script that will let me move the data from a "Color" field into a "Description" field against a set of found records. I would need to insert a comma and a space between the fields, so it is added to the existing data in the description field. I tried the Replace Field Contents with a calculation of
Description = Description & ", " & Color
but I have to create the calculation everytime for every found set of records and I also want to clear the "Color" field once the data from it is moved to the Description field. I'm not to clear on the looping script step.
Any help is appreciated!