Solved

Data Extraction / Conversion of Text File.  Solution on the cheap?

Posted on 2013-05-16
8
558 Views
Last Modified: 2013-05-30
Is there a cheap and easy-to-use software package which might enable me to extract pieces of data from a text report file into a more usable format?

I think a popular solution for this is something called Monarch but I think it's pretty expensive (I saw it for $1,000 on ebay).

Thanks,
Mike
0
Comment
Question by:mike2401
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 53

Expert Comment

by:Joe Winograd, EE MVE
ID: 39171962
Mike,
Please provide more details on what you're trying to accomplish. What pieces of data? Is there identifying metadata that precedes each piece the data? What do you mean by a usable format? Word? Excel? Etc? Regards, Joe
0
 

Author Comment

by:mike2401
ID: 39172209
It's for a user, and I only saw the text file briefly, but it looked like there were columns of data, and there were subtotals.  So, it seemed kinda fuzzy: like "I want the sale column, but I need to ignore any row with a sub total, and store the result in an excel file ( or another text file).

Thx

Mike
0
 
LVL 53

Expert Comment

by:Joe Winograd, EE MVE
ID: 39172375
Mike,
It sounds very doable, but we need the details. Perhaps you could post a sample input text file (being careful to remove any private/sensitive data) and a mockup of what the output Excel or text file should look like...or at least a detailed description of it. Regards, Joe
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mike2401
ID: 39172596
Thanks Joe,

I'm really just looking for a general suggestion on software products that do this kind of task, without costing an arm and a leg.

Any titles come to mind?

Thx

Mike
0
 
LVL 53

Accepted Solution

by:
Joe Winograd, EE MVE earned 500 total points
ID: 39172704
Mike,
I don't understand enough of the requirements to make an intelligent recommendation. If the needs are very specific, you may be better off writing a custom program than trying to utilize a high-end IT product like Monarch Data Pump. That said, I suggest you take a look at DataMystic's TextPipe product line:
http://www.datamystic.com/textpipe.html

The Pro version is reasonably priced at US$395, but perhaps you can make do with the Standard version at US$199 or even the Lite version at US$30. Here's a comparison matrix that should allow you to select the appropriate version once you have a good handle on the requirements:
http://www.datamystic.com/textpipe/pro_compare.html

There's even a TextPipe Pro SDK if your needs exceed what the off-the-shelf product can do:
http://www.datamystic.com/textpipe/com_interface.html

I don't use TextPipe, but I've been using DataMystic's DirDate for a long time:
http://www.datamystic.com/dirdate.html

It is a terrific product and the technical support has been excellent. Based on my experience with DirDate, I would not hesitate to use any of DataMystic's products. In addition, the evaluation copy of TextPipe Pro is a full-featured version (free to download) that will work for 30 days, which should be plenty of time to see if it can do the job for you. Regards, Joe
0
 

Author Comment

by:mike2401
ID: 39172869
Thanks @joewinograd, that sounds like some solid suggestions. I'm looking at them now.
0
 

Author Closing Comment

by:mike2401
ID: 39208590
Thanks again @joewinograd !
0
 
LVL 53

Expert Comment

by:Joe Winograd, EE MVE
ID: 39208602
Mike,
You're very welcome! Regards, Joe
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Password Management 4 46
Calibrating x & y screen  pixel coordinates 1 70
What program can open a .sig file image? 6 80
moto 4g plus phone lockout time 4 38
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question