VBA : Tools and Applications: Grep & Replace - clean text files from unwanted text
Grep & Replace searches for a certain string (optional begin and end substrings) in text files and optionally replaces it with another string.
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|
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|