Search found 18 matches

by jring
Thu Apr 01, 2004 4:25 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: A couple quick Thoughts.....
Replies: 0
Views: 9786

A couple quick Thoughts.....

password Protected filters? Database for Organizing Filters? Optimization Tool for Analyzing Filter Performance? Filter Migration for New TPP releases Wizard/Tool TCP/IP Socket Monitoring Filter Some things I've been thinking about putting together a bit at a time.... HTML Page Creation Filter MS Sq...
by jring
Fri Mar 26, 2004 7:12 pm
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: An Obscure Performance not-so-important Issue
Replies: 0
Views: 12474

An Obscure Performance not-so-important Issue

Simon - Interesting performance thing I noticed.. If I have a series of sub-filters, and I put a "remove blanks from start &/or end of file" at the end of the series of sub-filters, I often get a dramatic performance drop...however, if I put right after the 'remove blanks' filter, some irrelevant se...
by jring
Fri Mar 26, 2004 7:05 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Read from folder
Replies: 7
Views: 15212

I use that alot....

here's a little trick is a great way to organize files on a daily basis... ie. weblogs, email logs, stock information or anything where you may have lots of files spread out over time: 1. do the date > C:\date.txt trick to output the date into a .txt file. 2. Strip out extraneous info from the textf...
by jring
Fri Mar 26, 2004 6:52 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: unable to add value inside a text file
Replies: 2
Views: 8437

OUTPUT FILENAME STATS

You want to use the VB Script filter, "OUTPUT FILENAME STATS"

That will do exactly what you are asking...hmmm, you will need to change the string so that it includes the other values you mentioned

<<&>>
by jring
Fri Mar 26, 2004 6:48 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Pad Filename
Replies: 3
Views: 9812

yep..

I've done this sort of things with Textpipe via Command line textpipe combo... Dir "C:\director\of\choice" /b > C:\Dir.txt The output in the file will be: 123.txt 1234.txt 12345.txt You can now make a filter that creates a rename batch script which pads the filenames to 8 characters. assuming your f...
by jring
Fri Mar 12, 2004 5:04 pm
Forum: DataPipe Support
Topic: seperating names
Replies: 2
Views: 16418

SQL could do it as well....

I'm an absolute avid fan of TEXTPIPE and Datapipe, however, this particular challenge, I'd attack with SQL:

Select
LTRIM(RTRIM(Left(Column_X, (Charindex('v.', Column_X))) as NIXON_RON,
LTRIM(RTRIM(Right(Column_X, Len(Column_X) - Charindex(' v. ', Column_x)))) as DOLE_ROBERT
From Table_Full_o_Data
by jring
Fri Mar 12, 2004 4:58 pm
Forum: DataPipe Support
Topic: Move data from one column to another
Replies: 1
Views: 15566

the SQL For you....

If you just processed Column A and You would like to move the result to Column b, and Column B is in the Same table: Update X Set Column B = Column A if it's in another table and there is some kind of foreign key between the two tables: Update X Set X.B = Y.B From Table1 X, Table2 Y Where X.Key in (...
by jring
Fri Mar 12, 2004 4:56 pm
Forum: DataPipe Support
Topic: speeding up search and replace
Replies: 1
Views: 11606

hmmmm....

hmmm that's interesting. I ran a datapipe program for 3 days against a sql db and got 5 million rows with about 15 columns through.... I think the routine used a combination of 40 nested TPP filters... So your case sounds a bit perplexing.... I did learn a few tricks that may help: 1. Make sure the ...
by jring
Fri Mar 12, 2004 4:36 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Read from folder
Replies: 7
Views: 15212

hmmm... If I'm understanding you correctly,
you could goto a dos prompt and type:

dir /B > filename.txt
by jring
Mon Oct 27, 2003 11:38 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Why Expensive?
Replies: 2
Views: 12738

I've got to agree with Simon on this one....

As a poor entreapreneur that relies on TPP for many things, and really can't afford the extras, I've learned to suck it up my TPP costs for one simple reason: TPP is not just a product that does effective search and replace etc. In many respects, TPP is a development platform that is easier to use t...
by jring
Mon Oct 27, 2003 11:19 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Database Filter
Replies: 3
Views: 14214

Data-Base-Filter

OK. I've finally figured out how to use the darn thing! For everyone else's benefit, I'm going to explain where i got stumped, and the solution by walking through a quick example: I have a msAccess file with a table called [Test], and I want to extract everthing, convert to lowercase, and output to ...
by jring
Sun Oct 26, 2003 10:21 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Replace using Filename
Replies: 5
Views: 12457

You can accomplish your goal w/ a single batch file....

hmmmm...Since you want to use a unique replaced string on a pattern that is fixed across separate files, the only way I can imagine you could get from A-to-B in one go is by setting up a batch file.... If you use the below string, making only adjustments for: 1. Path to your textpipe.exe 2. /S0=XXX ...
by jring
Wed Oct 22, 2003 2:28 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Word Pair or Word Triplet Extracts
Replies: 2
Views: 9052

reply

hmmmm, interesting Q/A. I don't know how to write vb script, and I was able to create 2 filters that appear to have given me a solid jump on the problem. Simon - you know my email, send me and the guy who asked the original question a note, and I'll reply with my filters. Perhaps we can nip this one...
by jring
Tue Sep 23, 2003 9:14 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: replace everything after a particular character
Replies: 1
Views: 10016

Easy one!

http://www.domain.COM/example/index.htm OK this is a few steps, but this works really well: 1. Search Replace Exact: S: http:// R: http%%% 2. Search Replace Exact: S: / R: <carriage return> 3. Search Replace Exact: S: http%%% R: http:// 4. Extract URLS. 5. Remove Blanks from begginning line. 6. Remo...
by jring
Tue Sep 23, 2003 9:07 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Search and Replace - Too many times
Replies: 2
Views: 10611

Check 'Replace First Only" Box

Do this: Restrict to 1 Line at a Time:
Use Replace pattern - subfilter - Be certain to Check the setting box on the bottom of the filter that says:

"Replace First Only"

As long as you've got a handle on your search/replace pattern. This should work fine

J-