We've purchased TextPipe Pro for use here at work, and I have it installed successfully on my Windows 2000 machine. However, our user runs Windows NT, and her...
Hi Becky, TextPipe expects to be able to read from the registry entries under HKEY_LOCAL_MACHINE\Software\Crystal Software\* This is where TextPipe looks to...
Hi, 1) I have just begin using the Special > Database Connection filter. I am able to get results using (my desired) output style of 'XML Format'. But ...
Hi Allan, When an ODBC source tells TextPipe that a column is of type 'BLOB', then that's what TextPipe puts in the output - just the text 'BLOB', because the...
Problem: Pull out phone numbers from a file or group of files. Actually the problem is to extract all the phone numbers on a hard disk. The phone numbers can...
Hi Robert - Your filter is not working because when a select filter doesn't match something, it returns nothing, which is what the next filter gets to work...
A quick and dirty pattern match and replace should take care of this in most cases: Pattern [(\d\d?-\d\d?)-(\d\d\d\d)] with [$2-$1] Of course you might get...
I am using Outlook to collect emails from a questionnaire webform every few days. I export the folder full of messages to a Tab-Delimited TXT file and filter...
Hi Gilles, Try a pattern match of "(\d+)-(\d+)-(200\d)" and a replacement of "$3-$2-$1" Regards, Simon ... ===== Regards, Simon Carter, Crystal Software,...
Hi, How would you remove lines in one file that are not found in another, based on string matching? a.txt (source file - tab delimited) ... 324 mike 4 paul ...
Mike
anonymous@...
Nov 23, 2001 3:27 am
189
Hi Mike, You'd have to write your own custom filter using the Special Menu\ActiveX script filter, in VBScript or JScript. At the start, you'd have to load one...
Hi, How would I do this: Remove the duplicate lines based on character position: 00-1271-1 91 00-1272-1 54 (duplicate) 00-1272-2 54 (duplicate) 00-1276-1 41 ...
Mike
anonymous@...
Nov 23, 2001 7:35 pm
191
You could handle this with ActiveX script - but there is a way to get TextPipe to do it all without scripting. The key is the Sort filter, with the Numeric...
Hi, Bummer, I thought it could do aq sort on a select and wasted quite a bit of time on it. That would be totally useful. Thanks for the numeric sort tip,...
Mike
anonymous@...
Nov 24, 2001 12:47 am
193
Hi Mike, You'll have to write some VBScript code to check if the lines are duplicates. You can't use select filters for this because that's not how they work. ...
Hi Phil, This is a bug with the Append feature - a new version will be available over the weekend that fixes it up. Regards, Simon ... from a questionnaire...
Excellent news! Thanks Phil ... From: Simon Carter, Crystal Software [mailto:mail@...] Sent: 24 November 2001 08:32 To:...
Phil Swallow
phil@...
Nov 24, 2001 9:04 am
196
TextPipe 5.6.2 has been released. Below is a list of new features, and following that is purchase, upgrade and download information. ** When you purchase...
After I've completed all the "search and replace" operations I need to organize the data. There is 1 file, about 15-25 rows...I need to do some operations...
Does anyone have a suggestion on how I can use TextPipe Pro to slice a binary file into 100 character lines, properly terminated with a LF/CR combination? ...
Hi Jerry, Use a Convert\End of line characters filter, and make sure that they input filter is set to process binary files. Regards, Simon ... I can use...
I have to search very large files for a great hundreds of terms using Select Lines Matching. Is there a simple way, over than what I describe below, to do...
Hi Jerry, You can automate this by loading a file full of command line parameters using the /Z= parameter, and you can also script this from within VBScript or...
Hi Eugene, Can you please provide some example text? I am not sure what you mean, or if it's possible. Regards, Simon ... matching...." ... ===== Regards, ...
Hi there, Use a pattern match to re-arrange the text within a line, by grouping each expression in brackets, then re-arrange the output expressions when you...
Hello Simon, Here goes example text (pretty large amount of data :-) ... QU 5OUDT . ** 1\15\FA-MOQLLA\IN-000000\NC-4\LC-29SEP00/1308 2 ...
NTT International Tou...
info@...
Dec 4, 2001 5:21 am
206
I am trying to remove the following from EACH line of a text file.... (archive) (archive2) ("archive") I am ending up either removing a single paren or...