5 Replies Latest reply on Jun 19, 2013 1:55 PM by malibux14x

    Replacing field contents if empty

    malibux14x

      Title

      Replacing field contents if empty

      Post

           hello, i am trying to run through my records and replace any of the 10 fields with "0" if the field is empty but ignore it if it isnt.

            

           i have 10 fields that represent sixes, S, M, L....

           EX

           record 1:

           S-2

           M-5

           L-6

           XL-

           XXL-

           XXXL - 8

           34 -

           36 - 6

           38 - 2

           40 -

           Id like to run a script that will fill in the empty fields with a 0 but not erase or replace the field if there is a number already there.

           below is the scruipt i have been trying to make work.

            

           thank you in advance

            

            

      script.png