Hi Joseph, You can include the filename inside a file using the @inputFilename macro (in header/footer/left/right margins). To rename files, see one of the...
I'm trying to extract the info below into fields to import into a database or spreadsheet. Is it possible to use textpipe to extract everything after a colon...
Hi Ron, ... Note that this generates tab-delimited data to enter into a database, because some data has commas in it. You can also use the attached web page to...
I have a CVS file that can contain a couple of fields that could be over 8000 characters in length. This 8000 limit issue is on an program that we using for...
I'm trying to clean up a file, removing lines such as CopyTo: that is X: where X: is the only thing in the line and nothing appears after the : I don't want to...
Hi, I'm merging a directory of files (each file has one great big long single record in it of variable length) and inserting a CRLF between them, no problem...
Hi, Regarding my line wrapping problem... I identified space, hyphen and colon as being the characters that were causing the line to wrap prematurely so I...
Hi Stephen, You need to use Remove Matching Lines with a pattern of ^CopyTo:$ or ^CopyTo:(\s*)$ to absorb any extra spaces - which is probably why some of your...
Hi David, The best way to handle this is going to be with VBScript, acting as a subfilter to a Select CSV fields 47..47 filter. You can then use the VBScript...
Hi Howard, You can always use the VBScript/JScript filter inside TextPipe to do this. You could also use the Convert end-of-lines filter to split each record ...
Thanks Simon, I'll try it out - although the pressure is off now as we have sorted out the 'root' cause of the problem and my workaround is not required any...
Hello, I have TextPipePro 6.4.1 (TPP) and I have never been able to get the ActiveX filter scripts to work. Every time I try, a popup error message appears...
Hi Steve, This is the second report of problems with Win98 that we've had in the last 2 weeks. In theory, the script download from Microsoft should install...
Hi all, The next version of TextPipe will allow user defined patterns in the right-click menu of pattern fields. This will make it much easier to enter common...
Hi, I am relatively new to TPP and not (yet?) familiar with VBScript or other advanced filter-building techniques. I have a large data set consisting of two...
Hi there, You can either use the Special Menu/Move Columns facility to swap the columns around and then sort them, or you can tell TextPipe to sort based on...
I have a series of five text files that are all formatted as follows: STORMFLOW SUMMARY FOR CATCHMENT CV01 <<12 lines of data to be deleted>> 870317 1756...
Hi, If you have not resoilved this yet and do not need to do it very often,.the following will work. If you have access to EXCEL, I would use EXCEL for this....
Hi Allan, Excel may have trouble with a 10MB file- I could be wrong. I would use the attached filter to copy the data down, and reverse the sort order. ...
Hi Dan, I've done the hard work for you - the remainder is to remove the unwanted columns (easy) and remove the CV01 line (easy). Regards, Simon Carter,...
We've just realised that the Special Menu\Move columns facility can't be clicked on in the current release. You can work around this problem by using File...
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...
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.
