complex search and sorting files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

complex search and sorting files

Postby msmith » Thu Dec 20, 2007 1:26 pm


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

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 !


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

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.

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

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

Who is online

Users browsing this forum: No registered users and 2 guests