2 Replies Latest reply on Jul 17, 2012 6:30 AM by philmodjunk

    Addition of data retroactively

    NathanStrahl

      Title

      Addition of data retroactively

      Post

      I have about 100 records where I forgot to add  the letters 'nrsmd' to one field. Is there a way to add nrsmd to a given field retroactively for all 100 records in one fell swoop (globally) instead of one at a time?

        • 1. Re: Addition of data retroactively
          schamblee

          You could use a loop to locate the records and then replace the field contents. 

          This sample Loops thur Records for test::field1 with the contents "abc" and then replace the test::field1 with abcnrsmd

          Sample script :

          Go to Record/Request/Page [First]

          Loop

          If [test::field1="abc"]

            Replace Field Contents [No dialog;test::field1;test::field1 & "nrsmd"]

          EndIf

          Go to Record/Request/Page [Next; Exit after last]

          End Loop

           

           

           

           

          • 2. Re: Addition of data retroactively
            philmodjunk

            Replace Field Contents updates the specified field for every record in your found set, so it's the correct tool to use, but not inside a loop like this. Instead perform a find to pull up just the records you want to update and then do a replace field contents with the expression shown in the previous post.