Search found 2283 matches

by DataMystic Support
Thu Oct 23, 2003 8:53 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: sample copy paste, question
Replies: 1
Views: 8342

On the trial page, I think there was a bug with that version. One of Ctrl+V, or the Edit menu\paste, or right click menu\Paste will work.
by DataMystic Support
Mon Oct 20, 2003 11:17 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Why Expensive?
Replies: 2
Views: 12910

Sorry Colt,

In short, it's not expensive at all. $30 is peanuts for a corporation to fix up 100MB+ data files, when a consultant costs $70+ per hour (and one who knows what they are doing costs more). At that rate, even $270 for the full product is peanuts.
by DataMystic Support
Mon Oct 20, 2003 11:13 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Odd search and replace question
Replies: 1
Views: 8315

Hi Chris,

That file isn't one that is used or understood by TextPipe, but you can certainly use a text file to load filter settings into TextPipe. Just check the help under the Command line settings.
by DataMystic Support
Mon Oct 20, 2003 11:10 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Word Pair or Word Triplet Extracts
Replies: 2
Views: 9153

Hi Jeff, I'm pretty sure you can't do this with regex alone. You can however get a regex to match each word, and then use a VBScript subfilter to process those words - keeping an array of 2 or three words and outputting them. It looks like you're trying to generate a word concordance, which is somet...
by DataMystic Support
Fri Oct 03, 2003 5:38 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Database Filter
Replies: 3
Views: 14430

1a). Convert it to a INSERT INTO ... SQL form. See you database help for details on the format of this command.# 2a) Simple, with input 'select * from tablename;' b) See other post on copying data c) Tricky - could be done by taking 2b) and modifying it from 'INSERT INTO' to 'UPDATE <table> SET X=x ...
by DataMystic Support
Fri Oct 03, 2003 5:35 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Search and Replace Question
Replies: 1
Views: 9694

Hmm.

Try a pattern of

([A-Z0-9][ ])+([A-Z0-9])

add a subfilter to remove all spaces.
by DataMystic Support
Fri Oct 03, 2003 5:34 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Newbie on arithmetic - help request on arithmetic operation
Replies: 1
Views: 8542

Hi there,

Use a 'restrict to CSV field' to choose the data field first.

Then add a VBScript subfilter to calculate 1/x of the data and output it.

Have a look at the VBScript help and samples to see how this works.
by DataMystic Support
Fri Oct 03, 2003 5:32 am
Forum: FileWatcher, DirDate and other Support
Topic: Text File Input to Database Output
Replies: 1
Views: 9529

Hi - you don't need DPP for this. With the first database filter, have an input text of select * from tablename; set the database filter output format to 'insert script', for the new tablename. The result is a series of INSERT INTO ... statements. Add a second database filter, this one pointing to t...
by DataMystic Support
Fri Oct 03, 2003 5:30 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Automatic scripting or macro facility
Replies: 1
Views: 7868

Hi Mark,

If you mean the ability to script TextPipe - it's already there! Check the help file for details.

If not, please let me know in more detail what you mean.
by DataMystic Support
Fri Oct 03, 2003 5:29 am
Forum: DataPipe Support
Topic: seperating names
Replies: 2
Views: 16911

Hi Ron,

The first step is to create a copy of the database column - one for the left name, one for the right name. Then write two TextPipe filters for DataPipe - one to retain the left name, and one to retain the right name (before and after the ' v ' respectively).
by DataMystic Support
Fri Oct 03, 2003 5:27 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: correcting the alignment of table data
Replies: 4
Views: 12794

Hi Rob,

I'd replace each set of 6 spaces with a tab, or import it into Excel.
by DataMystic Support
Fri Oct 03, 2003 5:25 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Evaluation doesn't work
Replies: 1
Views: 10211

In DetachPipe, you must first select some attachments to work with before the buttons are undimmed.
by DataMystic Support
Wed Sep 10, 2003 4:29 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Newbie request converting line by line text to CSV
Replies: 2
Views: 10000

Try searching for pattern

([^\r\n]*)
([^\r\n]*)
([^\r\n]*)
([^\r\n]*)
([^\r\n]*)

Replace with

"$1","$2","$3","$4","$5"
by DataMystic Support
Wed Aug 20, 2003 11:12 am
Forum: WordPipe, ExcelPipe and PowerPointPipe Support
Topic: simply doesn't work
Replies: 1
Views: 8909

Re: simply doesn't work

Are you using the latest WordPipe 3.6.6? What version of Word are you using? Depending on Word bugs, you may have to force WordPipe to save changes - please see the options tab and read the help file. I don't get it. I've tried the evaluation version of WordPipe at least twice now (on different comp...
by DataMystic Support
Wed Aug 20, 2003 11:08 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Multiples "retain lines"
Replies: 2
Views: 11743

Re: Multiples "retain lines"

Hi Henri, Combine each word you want to retain with an OR | e.g. special|test Hello, I have a small problem and I feel stupid, but I do not know how to do using the "retain lines" (but can be also applicable to "extract matches" or "matching lines") in order to retain different lines. When the "reta...