Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.
1. Enter the caret character (^) in the appropriate field in the import file. When imported, it removes the characters that were previously in the field.
NOTE: If the field we are removing the characters from is a monetary value, the caret will change the value to a default of $0.00.
NOTE: The caret character cannot be used in Import to remove values linked to an existing record (e.g. Constituent record). This will generate an exception: Record does not exist.
In these cases we will need to manually remove the data directly on the record.
Connect and collaborate with fellow Blackbaud users.