1 Reply Latest reply on Dec 16, 2009 7:19 PM by Steve Wright

    Cleaning up...



      Cleaning up...


      My imports are full of extraneous data (astericks and underscores) that are required.

      I need to copy the field to another field that can be cleaned with a find and replace.

      How can I copy one field to another?



      Love this stuff... 15 years from now, I might know what I'm doing...

        • 1. Re: Cleaning up...
          Steve Wright

          You almost answered your own question.


          You can either simply run the find replace on the initial field, or if your concerned which it sounds like you may be...

          After creating the new field, run a replace field contents step and set the value to be that of the field you want to clean up.

          You can even combine this with cleaning up the fields contents


          For example :


          OriginalField   -  contains odd characters

          NewField - temp field for cleaning up OriginalField


          Ensure you have the correct found set, or all records showing.

          1. Click in the NewField, then choose the Records > Replace field Contents

          2. Choose replace with calculated result (specify)


          3. Enter something along the lines of


          filter ( OriginalField ; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz01234567890 ")



          Above will strip out any character which is not listed, so if you want dashes or commas etc, add that above and place the results into the NewField for you to check / evaluate.


          To do an exact copy, simply make the calculation state  : OriginalField