I am trying to Replicate a record (keep all the same address information and NameLast, but replace the Title with blank, First Name with blank, etc. to add family members to a DB. This is to make data entry easier so the person only has to change the Title, First Name, Phone Number, etc. for their spouse or child.
I have duplicated a record, and then used a script to replace some of the fields in the duplicated record with " " (i.e. blank space).
Everything works as expected except the fields that I want deleted have a "0" in them instead of nothing. When the script runs, it fills all the deleted fields with 0 instead of nothing.
Can someone help me?