Use this FREE module to enhance your data by performing such common tasks as upper lower casing, name parsing and address formatting.

If after watching the tutorials you feel that you still have questions or comments on how to improve them please contact us.

The duration of the screencasts are in minutes and seconds. You will need to turn on your speakers because all of our tutorials have voice narration.

You can also check our latest version section to see changes and updates that might not have made it into the tutorials.

Cleanse Data Tutorials

Enhancing and Cleansing Your Data

Parse Address Lines Address Parsing Part 1 Easily identify street address, city, state, province, postal or zip code, from several address lines. 2 min 50'
Parse Address Lines Address Parsing Part 2 Extract city, state and zip. Or city, province and postal code from a single data column with ease. 2 min
Parse Street Addresses Street Parsing Isolate street elements, such as apartment number, street type or direction, from multiple street addresses. 1 min 54'
Parse contact name Full Name Parsing Part 1 Extract name components from a person's full name. 2 min 58'
Parse Multiple Contacts Full Name Parsing Part 2 Split multiple contact names that are stored in one data field (e.g. John and Jane Smith). 1 min 56'
Gender Code Records Gender Coding Append a gender code based on name components or a full name of an individual. 2 min 21'
Summary Reports Tally Reports Quickly generate summary, distribution and frequency reports based on metrics in your database. 1 min 25'
Questions about setting up Pre Post Office
 

I have multiply names in one data field. Can I extract only one contact name?

Answer

Yes, you have the option of splitting out only one contact name. Have a look at the tutorial Full Name Parsing Part Two.

 

Did we answer your question? If not contact us and you will get an answer promptly.