Global Replace a Field Using a Dbase Expression

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”

Leave a Reply