complex search and sorting files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
msmith
Posts: 1
Joined: Thu Dec 20, 2007 1:18 pm

complex search and sorting files

Post by msmith » Thu Dec 20, 2007 1:26 pm

Hello,

I was wondering if TextPipe Pro could do the following:

I have a list of all productnames.

I want to search all files on any productname and then create a seperate resultfile for each product.

So for example, the list is:
Product A
Product B
Product C
etc

Then I like to perform a search and filter out every line with "Product A" and put this in file proda.txt - same process for "Product B" etc.

So I end up with exactly the same number of files as the number of products in my "searchlist".

I found out it is possible, but the solution I found so far requires a manual input of every productname and filename, so to say, search Product A and put results in proda.txt .. But because the list is quite big, I would like it to read the text file containing all products and go thru them one by one.

Speed is not an issue, just an automated process is.

Thanks for advice and I have to say I am impressed with the trial product so far !

Michael

User avatar
DataMystic Support
Site Admin
Posts: 2220
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support » Mon Dec 24, 2007 2:55 pm

Thanks Michael :-)

The best option is to use JScript or VBScript outside of TP to create your filter on the fly. First create a simple filter for one product type. Then File\Export this to VB/JScript to see the general structure, then automate this to get the results you need.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest