Search found 2290 matches

by DataMystic Support
Thu Nov 06, 2003 6:58 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: TextPipe 6.6.3 has been released
Replies: 0
Views: 9229

TextPipe 6.6.3 has been released

It will be announced next week. In particular, check out http://www.crystalsoftware.com.au/textpipe/wizard What's New in v6.6.3 ==================== * Vastly improved sorting performance for files larger than 50 MB. * Simplified user interface by removing 1. Comments tab (old comments are now insert...
by DataMystic Support
Thu Nov 06, 2003 6:56 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: macro
Replies: 4
Views: 15404

Good idea.

What format should it be inserted in? System full date format, system short date format, or perhaps a different macro for each format.
by DataMystic Support
Thu Nov 06, 2003 6:55 am
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Did I miss something?
Replies: 5
Views: 22889

Hi Christian,

Yes, this can certainly be done.

Use a pattern match to capture the header fields, and use a VBScript sub filter to save them to global variables.

Then when you process the detail lines, use another VBScript filter to output the values of the global variables on each line.
by DataMystic Support
Thu Oct 30, 2003 2:47 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: TextPipe Wizard in 6.6.3 Beta
Replies: 0
Views: 9165

TextPipe Wizard in 6.6.3 Beta

Hi folks,

Please checkout

http://www.crystalsoftware.com.au/textpipe/wizard

this will replace the wizard currently built into TP.

Any thoughts or feedback?
by DataMystic Support
Thu Oct 30, 2003 2:45 pm
Forum: WordPipe, ExcelPipe and PowerPointPipe Support
Topic: Does work - simply
Replies: 1
Views: 9081

Thanks Gavin,

Presumably you also bought it?
by DataMystic Support
Mon Oct 27, 2003 4:00 pm
Forum: DetachPipe.com and DetachPipe Add On Support
Topic: Database Filter
Replies: 3
Views: 14553

Hi Joseph, The help for the database filter also describes this process, although I'm not sure it it's in the current release (definitely in 6.6.3 beta). Here it is again anyway: Add a Special Menu\Database filter Configure it to point to your database using the Build button e.g. to the Northwind da...
by DataMystic Support
Thu Oct 23, 2003 8:56 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: RTF-format; replacing of strings
Replies: 1
Views: 8275

Hi Rolf,

In short, I don't know. RTF format, although well documented by Microsoft, still takes a lot to understand. If I were you, I'd look at the nearby tags and work out a rule of thumb so that only the sections you want changed are actually changed, and then use TextPipe's subfiltering to do so.
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: 8455

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: 13018

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: 8437

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: 9289

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: 14553

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: 9781

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: 8656

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: 9618

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...