AnsweredAssumed Answered

Replacing field contents if empty

Question asked by malibux14x on Jun 18, 2013
Latest reply on Jun 19, 2013 by 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

Outcomes