Hi TextPipers. Recently we were asked to provide an example of converting a CSV file to fixed width. The attached example shows how this can easily be done,...
I'm trying to extract names and salary information for some 10-K filings. I see a filter to extract emails from a text file, anyone have suggestions for how to...
Hi Ron, Could you post an example file? Regards, Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888 3104 (GMT+10 hours) TextPipe Pro -...
Hi Ron, Attached is a filter that 1) Eliminates surrounding data that is not required 2) Keeps only those lines with a date in them (a 4 digit number) 3) Then...
Hi, I am trying to take the documentation at the top of our programs and turn it into a more legible comment. Within the programs, the doc. is often IN UPPER...
Hi Ron, Sorry, that filter was from the latest beta. It's attached from v6.5, and the Export text is below. ... +--Output to file(s) [ ] Test mode [ ] Only...
Hi Allan, That's dead easy! If you add a sub filter to the Perl search/replace, then the sub filter is restricted to act inside the replacement text. So all...
Hi We have what seems like a simple task, but so far are stumped as to how to do it. We have a CSV file. We want to replace all the text in one of the fields...
Hello All, I am new to this list. I am trying to do some manipulations in the email file. This will eventually be imported into an askSam database. Here is the...
Hi Bill, Use a Restriction filter to limit a search and replace to just one field. To add a new CSV field, why not use a Insert left margin or Insert right ...
Hi everyone - I just installed TextPipe yesterday to go with my new AskSam database! I am now thinking that TextPipe won't let me do what I had hoped, based...
Aimee, I can't help you with the Textpipe filter, but I will point out that you probably do not want to use the file creation date to establish the original ...
Hi Shawn, The basic approach is to use a line restriction filter to copy the lines into a global variable (using a VBScript sub filter). Then you have to use...
Troy - Thanks for the comment - hmm. That will be a problem. I thought that the created date was a fixed date. Here's my concern: say a file created in...
Hi Aimee, If you plan to retain your original Word document format, then you can't use TextPipe for this. However, if you first convert the Word documents to...
Simon, Thanks for your help but when I try to open the filter you sent I get an error message that reads: Error reading TFilterList.FilterList: Errpr reading ...
Hi Sean, Are you using TextPipe 6.5.1? Regards, Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888 3104 (GMT+10 hours) TextPipe Pro -...
I need to be able to read through the file identify what lines should I use to split the file, then I need to create n number of split filters and break up...
Hi Alex, You can't split the file using the VBScript filter, although we have been considering requests to be able to split and/or rename the file from VB....
I created 2 VB scripts now and 1 split script: 1. Collects misc data, identifies what lines should be file splits. After processing (EndJob event) I save...
Hi Alex, All filters run simultaneously. That is why TextPipe doesn't need to use temporary files at all. It looks like you will have to run the two scripts...
Hi TextPipers, Attached are two filters for TextPipe 6.5+ that provide an extensive array of filters for manipulating CSV and Tab-delimited data files. *...
Afternoon All, I acquired TextPro only a couple of days ago but already recognize what an extraordinary tool it is. I have a problem that I'm not sure can be...
Phil, We are working on your question and you will be answered very soon. Thanks, Pedro GKG SUPPORT...
Peter Garza of GKG.NET
support@...
Jun 29, 2003 11:57 pm
482
Hi Phil, TextPipe Pro will do this. First eliminate the REF lines with a Remove matching lines filter. Then use a series of pattern match replaces to isolate...
Simon, On the 'Files to Process Tab', when working with all files (*.*) in a folder, it would be helpful to ONLY look at files modified after a certain date....
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
