Fundamentals > Working with Data > Data Quality >

Data Cleansing

Data cleansing fixes inaccurate and inconsistent data for new or modified account, contact, and prospect records. The data is fixed as follows:

Address Correction

Addresses are stored in a consistent format. For example, 1855 South Grant Street, San Mateo, CA 94401 becomes 1855 S. Grant St., San Mateo, CA 94401-3256.

Standardization

Names of contacts, accounts, and prospects are stored in a consistent format. For example, Siebel Systems, Incorporated becomes Siebel Systems, Inc.

Capitalization

Names and addresses are converted to mixed case, all lowercase, or all uppercase. For example, john smith becomes John Smith.

Truncation

Any hyphenated names in the First Name field are truncated so that only one name is stored in the field. For example, Jean-Paul becomes Jean.


 Fundamentals 
 Published: 14 August 2003