Parsing & Data Identification
Parsing is how DataRight IQ recognizes the meaningful pieces inside a record and separates them into individual, usable components.
What parsing is
Parsing means identifying and isolating one kind of data from another. DataRight IQ reads a field - even one containing a jumble of different information - recognizes the distinct elements inside it, and breaks them into individual components you can place wherever you need them.
For example, a single free-form name field can be parsed into prename, first name, middle name, last name, and postname, each in its own field.
What DataRight IQ parses
| Data type | What it identifies |
|---|---|
| Names | Multiple names per record, each broken into components such as prename, first, middle, last, and postname. |
| Job titles | Multiple job titles per record, separated from the names they belong to. |
| Firms | Firm names and firm locations, with optional conversion of firm names to widely accepted acronyms (for example, General Motors -> GM). |
| Addresses | U.S. address lines plus city, state, and ZIP Code data, separated into structured components. |
| Email addresses | Email values identified and broken into their component parts. |
| Phone numbers | U.S., Canadian, and international phone numbers, separated into components with phone-type information. |
| Dates | Date values recognized and parsed into fields, with format conversion available. |
| Custom patterns | Your own data formats - such as account, policy, or reference numbers - identified with user-defined pattern matching. |
Free-form & floating data
One of DataRight IQ's core strengths is handling data that isn't neatly fielded. When information "floats" - appearing in different fields from record to record, or mixed together on a single line - DataRight IQ can still recognize each element and route it to the right place.
- Identify individual elements inside unstructured, multiline, or mixed-content fields.
- Turn floating data into clean, fielded data that's consistent from record to record.
- Recognize different data types within the same field and separate them appropriately.
Associating related data
Beyond isolating individual values, DataRight IQ understands relationships between them. It can keep related pieces of information connected as it restructures a record.
- Associate a job title with the specific name it belongs to.
- Handle multiple names and titles within one record.
- Recognize dual names and their associated titles.
Tailoring parsing to your data
Every organization's data has its own quirks. DataRight IQ can be extended so parsing reflects the names, terms, and formats specific to your business.
Custom dictionaries
You can extend DataRight IQ's knowledge with custom dictionaries so it correctly handles local or regional names, industry-specific jargon, particular phrases, firm names that look like personal names, and preferred capitalization.
User-defined patterns
When your data includes formats unique to your organization - such as internal account or reference numbers - user-defined pattern matching lets DataRight IQ recognize and parse those formats alongside everything else.