Astera introduces the newest addition to the platform, Astera Data Services - a complete API lifecycle management solution. Learn More

X

Saving Time and Ensuring Data Quality with ReportMiner Automatic Name and Address Parsing

By |2022-10-18T10:31:06+00:00July 28th, 2015|

Many times people have a single address field from a data source that has all the address information in the one field. They need to parse out the individual sections of the address into separate fields so it can be loaded into a database and/or combined with information from different sources. Often there are thousands of records that need to be parsed and to do this manually is a time-consuming and error-prone task, putting your data quality and reliability at risk.

Astera’s ReportMiner data extraction software automatically parses name and address data with a few simple clicks, ensuring your data quality and saving you resource time and money.

ReportMiner breaks up the name and addresses data into separate components such as Name: prefix, first, middle, last, suffix and Address: street, suite, city, state, zip, country.

Once your Data Region has been created, you simply highlight the name area, right click and select “Add Name Field.” You do the same for addresses: Highlight the address area, right click and select “Add Address Field (US).” ReportMiner will automatically create your name and address fields by breaking them up into individual fields.

For more information on creating data regions and fields in ReportMiner, check out our blog Smart Data Extraction with ReportMiner: Automating Creation of Extraction Models.

Related Articles

Why Data Extraction Automation Is Essential for Business Growth

The modern world relies on data. There’s a huge amount of data that runs through an organization with every process,...
read more

Automating Data Extraction Processes for Energy Sector with Astera ReportMiner

The energy sector is in the midst of the biggest technological disruption. Efficient data management has become one of the...
read more

Manage Unstructured Healthcare Data with Astera ReportMiner

Healthcare data is growing in velocity, volume, and variety. You need to focus on effective data management to get rich,...
read more