1 2 Previous Next 29 Replies Latest reply on Oct 12, 2016 1:45 PM by MartyGlenn

    IsEmpty Replace with another Field Contents

    MartyGlenn

      Hello

       

      I have a very large DB and have created a small file.  The issue is this:

       

      1. There are 400K line items

      2. On some of the records there is a field that is empty (About 90K)  This field name is: CONCAT_Desc

      3. I want that field (It is a concatenated field) {Isempty} = true to be replaced with the contents of another field. That field name is: ProductName

       

      Script

      I have tried so many different ways but I cannot seem to get the script to basically search the CONCAT_Desc field and check if its empty and if it is replace it with the contents of ProductName

       

      Now how hard can that be lol

       

      - Marty

        1 2 Previous Next