Data Parsing
Download

Data parsing is the process of splitting data out into its constituent parts so you gain additional value and insights from your existing customer data.

For example:

  • An email address is made up of components (Mailbox (Local part), Domain, Top Level Domain (TLD)
  • A Telephone number has multiple components (Country, Number, Prefix, Type)
  • A website (URL) has components (Host, Scheme, Port, Path).

All of these can be split out to provide separate data elements for better analysis and use.

That,Is,How,It,Works.,Smiling,Businesswoman,Experienced,In,Work

Parse Use Case Examples

Parse allows you to analyse and resolve data into its component parts. 

Email
Email

Identify the parts of an email addresses to separate into different fields i.e. mailbox, local part, domain and top-level domain.

Email Mailbox Local Part Domain TLD 
test@example.com test@example.com test example.com com 
Phone
Phone

Identify the parts of a phone number to split into different fields, including: extension, national number and number type by inputting only a phone number and a country identifier.

Input 

Phone Number Country Identifier – ISO 2 
+447511111111 GB 
02392111111 GB 
0344 800 2400 GB 

 

Output 

Country Code Extension National Number Number Type 
44  7511111111 MOBILE 
44  2392111111 FIXED_LINE 
44  3448002400 UAN 
Website
Website (URL)

Identify the parts of a URL (Website) to split into different data fields. i.e., host, scheme, host name type, port, path and query from one or more URL’s.

URL Address Host Scheme Host Name Type Path and Query Port 
https://www.microsoft.com/home www.microsoft.com https Dns /home 443 
http://www.google.com/example?value=1 www.google.com http Dns /example?value=1 80 

Business Benefits of Customer Data Parsing:

Efficient Data Processing
Enhanced Data Accuracy
Improved Search and Retrieval
Enhanced Analytics and Reporting
Data Enrichment
Scalability

Why Parse Data in Excel?

Unlock Additional Insights

Data parsing involves breaking down customer data into its fundamental components, allowing for deeper insights and added value from existing datasets.

Improved Search and Retrieval

Parsed data allows for more efficient search and retrieval processes, enabling quicker access to specific data elements within large datasets.

Enhanced Analytics and Reporting

Parsed data elements facilitate more detailed and accurate analytics and reporting, offering granular insights for informed decision-making.

Data Enrichment

Parsing enriches existing datasets by extracting specific components, providing enriched data for deeper analysis.

Solutions

Email

Phone

Install DQ for Excel within minutes for complete control over your customer data.

This is how easy it is:


Warning: Undefined array key 1 in /home/customer/www/dqforexcel.dqglobal.com/public_html/wp-content/themes/Eldo/template-parts/flexible/calltoaction.php on line 63

Make an Enquiry

Product and account support