|
|
Extract Data From Non-Structured Text File
"Hi Experts,
I have a text file (EP-User.txt) contains records of User information like the example below:
[User]
org_id=HR
uid=JohnChen
role=employee
email_address=John@etex.com
first_name=John
last_name=Chen
job_title=Manager
country=USA
language=EN
time_zone=GMT-8
street=3
city=MX
state=NY
zip=123456
telephone=09847684
fax=23469483
$serviceUser$:SERVICEUSER_ATTRIBUTE=IS_SERVICEUSER
[User]
uid=AndyKoh
email_address=Andy@etex.com
org_id=HR
first_name=Andy
last_name=Koh
job_title=Director
country=USA
language=EN
role=employee
time_zone=GMT-8
street=3
city=MX
zip=694724
telephone=08362843
fax=23469483
[User]
org_id=SALE
uid=MarkLee
role=employee
email_address=Mark@etex.com
first_name=Mark
last_name=Lee
time_zone=GMT-8
city=MX
state=NY
fax=23469483
The fields of each User record may not appear in sequence and some of the fields may not appear in other User record. The file contains thousands of User records.
1. I need to extract the User records (only certain fields) into excel for data analysis and manipulation (fill-in missing value in certain fields).
2. After analysis and manipulation in excel, I need to export the data back to the original text file format again."
Relative Articles:Extract Data From Websites,Extract Data From Web Pages
Web2DB Service for: Extract Data Text File,Extract Data From Websites,Extract Data From Web Pages
Web Data Extraction Big Picture |
| Screenshots of Examples |
|
| Web2DB
Data Service |
You receive the
extracted
structural data directly.
Get your data in several days after
we start your project!
|
|
| Web2DB Custom Extractor |
You run the extraction
in your house at any time.
Get your data in minutes after
clicking the "Start" button!
|
|
|
