VBA : Tools and Applications: Grep & Replace - clean text files from unwanted text 
Options: Télécharger en PDF | Télécharger la pièce jointe |
Details:
| Type: | miscellaneous |
| Ajouté par: | Rembo |
| Courte Description: | Grep & Replace searches for a certain string (optional begin and end substrings) in text files and optionally replaces it with another string. |
| Détails: | 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 |
| Ajouté le: | 27 mai 2010 à 15h21 |
| Liens connexes |
Usage:
Download the Excel application on http://excelpages.serve-it.nl/grepnreplace and double click it to open. Make sure enable macros.
Commentaires des membres : |
| Nouveau commentaire | Haut de la page |

