2 Replies Latest reply on Jan 29, 2013 2:51 PM by philmodjunk

    Remove Text Format on Existing Records

    AndrewCohn

      Title

      Remove Text Format on Existing Records

      Post

           Hi all,

           I recently discovered a field in my database being used for web publishing allowed for text format - Bold, Italic, etc, but this simply not needed as that formatting won't show up on our web store.  I changed the field to do a TextFormatRemove(Self) calculation on it, and even unchecked "Do Not Replace Existing Value in Field", hoping that it would update all existing records and eradicate the formatting.  However, it didn't (it only changed by going in, editing the record, undoing the change, and exiting field) so I need to cook up a script real quick to clean up all the records.

           It'd be a loop of course, but I'm not sure how to write a script step to do this.

           Start Loop

           Set Field PRODUCTS_tog::WebBlurb

           ????

           Go to Next Record, Exit Last

           How can I make a script to touch each record and deal with the new calculation in place for the field?