complex search and sorting files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

complex search and sorting files

Postby 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: 2136
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby 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


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 2 guests