You could use ActiveX scripting to summarize the data: option explicit dim last_unit, unit, sqft, min_sqft, max_sqft, lease, min_lease, max_lease function...
Thanks... When I run your script, I get 1/1 597-597 515-515 1/1 597-611 515-564 1/1 597-700 515-587 1/1 597-800 515-720 2/2 815-815 771-771 2/2 815-900 771-797...
Nevermind regarding my last question....but I do have a different, related one. When I run the below script, it's in the middle of alot of other data which I...
Hi syaktin, You'll have to code it manually using a VBScript filter. There is a similar example filter (in the vbscript folder) that splits records from one...
I have a database in TXT format and I want to remove lines based on domain names such as "aol.com." It's late and I'm drawing a blank as to how to do this in...
Hi Jerry, Use the 'Select lines NOT matching...' filter with a pattern of 'aol.com' and no subfilters - this will delete all lines that don't match the...
Hi, I have 8 separate database files, all of which share a common key. Is there a way to merge these db's into one large file based on the keys. i.e., all...
David, can you use a SQL database? SQL is the best way to do what you want. You can use TextPipe to shoot the data into the SQL database using the Database...
I need to change the following: 10:24:12:30: to, 10/24 12:30 Mapping changes all of the colons commonly. This may be a simple one, but I'm not sure of the...
Change your pattern perspective from ":' to "/" to "xx:xx:xx:xx:". Then the results pattern is "xx/xx xx:xx". [Simon: I'll just add a little to that answer to...
G Thurman
gthurman@...
Mar 31, 2002 11:11 am
255
Noel, Try the following filter. ... You should read the online help for Search and Replace, specifically the part about 'Replace With' where it describes how...
Did you try a search and replace using the 10:24 and changing it to 10/24? I find that works quite well and only changes the ones that are found ... From:...
Could someone possibly help me with this? I am trying to perform the following.. Input record 2099 Special: The World of Doom Output needed 2099 Special: The...
Hi I'm using pegasus mail. This program allows me to export the mails to files. But the mails are written to the files with the full header. Is there a way to...
It is clearly simple enough to automate TextPipe, however does anyone have a means of automatically checking for new files to be filtered e.g.- polling every...
Thomas, Take a look at the QEml.fll filter I have just uploaded. It does somewhat similar to what you need. Yuri. ... [Non-text portions of this message have...
You didn't state what platform, O.S. etc. If under Windows, select Start/Help. In the search area, enter 'task'/Go....
G Thurman
gthurman@...
Apr 5, 2002 9:57 am
263
Thanks again Simon...yes, that would be very useful. Even if TextPipe needed to stay open and this would run the filter every "x" minutes, hours, etc. it...
Ok, say you have a certain type of file (eg- file.txt). In some cases, depending on the content, you want it to run your existing filter and rename the file...
Answering my own "Polling/Automation" question, I found an excellent program called Automate 4 that took care of this with only 1/2 hour to make it work...
I have a question concerning an issue I have been dealing with off and on for the last couple of years. Here goes .. Occasionally I run accross an instance of...
... Yuri Where did you upload the QEml.fll filter to? Ed "Power corrupts. Absolute power is kind of neat." (John Lehman)...
Edward M Tobin
ETOBIN2@...
Apr 6, 2002 12:51 pm
269
... Naturally enough TextPipe doesn't have a filter for this, but you could whip together some VBScript code to do it pretty easily. I'll leave it as an...
Noel and EVERYONE, Do you know if Automate 4,Textpipe or any other solution exists for the following (or any other advice would be appreciated.) At my software...
CBJH, Check out my inline evaluation macro example in the files section: http://groups.yahoo.com/group/textpipe-discuss/files/inline%20macro.fll It's been a...
Dear Yuri Your filter works excellent. But please excuse for adding another question: I tryed to change some of the filter. It worked very well with removing...
... Reply at bottom .. ... 20macro.fll ... can imbed small vbscript expressions in text, and this vbscript filter will evaluate them and replace them with the...
Hello John! I think you could do something similar to what is shown below. Yuri. 1. Replace perl regexp ([^\r\n]+?)(\r\n)?? with $1\r\n$1\r\n Subfilters: 1.1....