I had a customer who wanted to Update the Company field so that it would say: The “Lastname” Family (ie, The Ritter Family, The Johnson Family, ) for all contacts.
The way to do this is to do a Global Replace using Advanced Options and then choosing to update using a dBase expression.
The Expression to enter is “The ” + Trim(Contact1->Lastname) + ” Family”
FYI – Notice the extra space after The and before Family: “The(space)” + Trim(Contact1->Lastname) + “(space)Family”
