Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)
COURSE of the MONTH
8 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Data Extraction / Conversion of Text File. Solution on the cheap?
Posted on 2013-05-16
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
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
[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
Active today
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
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
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
Thx
Mike
Active today
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
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
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
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
Active today
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
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
Featured Post
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!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This article was originally published on Monitis Blog, you can check it
here
.
If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sourc…
- Software-Other
- Web Applications
- Magento
- Web Development Software
- Monitis
- Networking, *magento2
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
Suggested Courses
Course of the Month8 days, 22 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.