Scriptorium

us fr nl




VBA : Tools and Applications: Grep & Replace - clean text files from unwanted text   nl


Options: Save as PDF | Save attached file |

Details:

Type: miscellaneous
Added By: Rembo
Short Description:
Grep & Replace searches for a certain string (optional begin and end substrings) in text files and optionally replaces it with another string. 
Notes:
Grep & Replace

* searches for files with specific extensions in a directory
* optinally searches in subdirectories of the main directory
* is able to exclude files created before a certain date & time
* searches for a very long strings that start with a specific substring
* optionally searches for long strings that end with another specific substring
* remove the found strings (thus cleaning the text file) or replace it with another string
* count the number of matches
* count the number of directories it found matches in
* optionally stores my settings

See also the screenshots at http://excelpages.serve-it.nl/grepnreplace
Added: May 27 2010 at 3:21 PM
Related URLs


Usage:

Download the Excel application on http://excelpages.serve-it.nl/grepnreplace and double click it to open. Make sure enable macros.



User comments :

Add a new comment   Back to Top
Atom Feed
Contact | About This Application | Scriptorium Website