Automated Solutions Direct, Inc. - 978-658-4700
Direct Marketing and Data Services since 1986
 

Request Quote

List Cleanup Services
Data Entry
978-658-4700 x 304
Send us an Email
 
Field Parsing Overview

Anyone who works with mailing lists soon learns that they come in many different format variations. Some have full names in a single field while others have separate fields for each name component. Some have city, state and zip on one line and others break them apart. Before these lists can be productively utilized these variations must be standardized.

 
Name Parsing

Split full name fields into individual components: Prefix, First Name, Middle Name, Last Name and Suffix.

Input Field

Data Sample

Full Name

Dr. & Mrs. John G. Clark, Jr.

 

 

Output Fields

Data Sample

Prefix

Dr. & Mrs.

First Name

John

Middle Name

G.

Last Name

Clark

Suffix

Jr.

 
City, State, Zip Parsing

Split a combined City, State, and Zip address line into individual fields.

Input Field

Data Sample

Address Line 3

Boston, MA 02110

 

 

Output Fields

Data Sample

City

Boston

State

MA

Zip

02110

 
Transmit a File for Processing

Send your file(s) via the transmit a file link below. We accept standard ASCII, dBase, Excel and many other file formats.

Transmit a File

Input Data Required

Output Data Returned

  • See Input Field List(s) Above
  • See Output Field List(s) Above