March 23, 200619 yr We are trying to add information to a field, to multiple records. We want to tag information to all of our records from a particular find. However there is no common data in the records to "find" in order to add (replace) the information. Is there an easy way to do this. Thanks
March 23, 200619 yr Hi If I'm understanding your situation correctly, you currently have data in a field, and you want to append some additional data to what exist. if so, then you could use a script such as: Go to Record/Request/Page [ First ] Loop Insert Calculated Result [ [color:blue]YourField, [color:blue]YourField & "[color:red]this is added on" ] (note: you might need to add a space between what exist and what is added (i.e. " [color:red]this is added on" [ Select entire contents ] Go to Record/Request/Page [ Next, Exit after last ] End Loop [color:red]Always use a copy of your file to experiment with. and be sure you only have the records in your found set that you want to append data to. HTH Lee
March 23, 200619 yr Author hmmm I think you are understanding me correctly.. is there a Non script way of doing this? any find and replace method?
March 23, 200619 yr You can use the "Replace" in the menu with a Calculated Result. Place your cursor in the field to be changed [color:blue]Go to Menu >> Records >> Replace Contents A second Dialog box will appear. Click on [color:red]Specify Choose your field in the Left box click on the Ampersand and then Quotes and type your data between the quotes. [color:blue]YourField & [color:red]" your added data." Same cautions as my last post. Lee
Create an account or sign in to comment