[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

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

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
mike2401
Asked:
mike2401
  • 4
  • 4
1 Solution
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
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
 
mike2401Author Commented:
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
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
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!

 
mike2401Author Commented:
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
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
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
 
mike2401Author Commented:
Thanks @joewinograd, that sounds like some solid suggestions. I'm looking at them now.
0
 
mike2401Author Commented:
Thanks again @joewinograd !
0
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
Mike,
You're very welcome! Regards, Joe
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now