Search and replace in many text files

If necessary, change currency unit from "Dollars" to "Euros" for example. Use Excel to import and export tables to and from a html database. Change multiple phone numbers to meet a specific style. Switch between commonly used files easily.

Also, shuffle entire rows or entire columns but still maintain some order. Arrange sort cells alphabetically or chronologically. Sort by second, third or nth character. Sort by second, third or nth word. Sort by position or referencing surrounding character s. Sort by only alpha, numeric, alpha-numeric or non-alpha-numeric character s.

Sort by cell content backwards. Finally, sort by cell length, format, color, font or date. Select a block of cells to change and specify how many digits to retain. Add character s to beginning, end or inside by position or referencing surrounding character s. Some Excel files do not reduce as well as others. Split by referencing spaces, commas or user-defined character s.

Splits can be applied to a block of selected cells. Also, reverse cell content so that it reads backwards. Use Excel to import and export tables to and from ASE databases. Use Excel to import and export tables to and from ASA databases. Convert length, weight, volume and temperature. Units include: inches, centimeters, millimeters, miles, kilometers, meters, yards, feet, pounds, kilograms, fluid ounces, ounces, grams, tons, quart, gallon, liter, Fahrenheit and Celsius.

For example, change "city, state" to "zip" or "zip" to "city, state". Also, add leading and trailing zeros to zip codes. Extract lines that do not contain specified text. Extract text between specified starting and ending character s repeatedly throughout file s.

Extract the same line s by number from multiple files. Save results as a text file. Duplicate email addresses are automatically removed. Select a block of cells and eliminate all redundant or unique data. Results can be placed on top of the selected cells themselves, in a new list next to the selection or in a new worksheet. Extract text between specified starting and ending character s repeatedly throughout multiple site s.

Duplicates are automatically removed. Similarly, delete text between specified starting and ending character s. Extract the same line s by number in file s. Input files must contain known state abbreviations for extraction. Save results as a single file or multiple files.

Provide news server, login and target newsgroup. Extraction occurs slowly. Backups can occur every 5 minutes, 30 minutes, 1 hour, etc. New files will be copied so that both folders are identical.

Synchronize an office computer with a home computer with this program. Specify which folders or drives to scan. Find unused files that are no longer needed. Find files that have recently been created or modified. The tables can be located in the same hypertext database or two different databases. Case of each word in each field column is changed. Provide the file locations for both databases to connect. Remove character s to beginning, end or inside by position or by referencing surrounding character s.

Save result as a new file. Save results as a new file. Sets of words can be loaded and saved as a file. MP3 files can be split by a specified amount of seconds and minutes. Extract parts of a field by specifying starting and ending character s. Specify fields columns to use as criteria. Provide the login information for both databases.

Remove character s at beginning, end or inside by position or by referencing surrounding character s. The tables can be located in the same MySQL database or two different databases. Output can be fully customized to contain database field names as tags. In the resulting text file, each field column is separated by a comma or other specified character.

Specify which fields to save in the table. Notes serve as to-do lists or reminders. Notes can be set to play an audio alarm at a specified time. The tables can be located in the same database or two different databases. Change case to upper, lower, proper title or sentence case.

Add character s to beginning, end or inside of file. Remove and replace character s. Adobe Acrobat required. Split by a specified number of pages. An option exists to automatically change the title field to the filename. Some fields can not be viewed as changed in Adobe Reader 8. The tables can be located in the same html database or two different databases.

Images will not be saved. Text found within an image will not be saved. Specify files to be joined and a new file consisting of all slides from each file will be created. Some files do not reduce as well as others.

Even, odd and prime numbers can be randomly generated. Add character s to beginning, end or inside of folder name by position or by referencing surrounding character s. Add character s to beginning, end or inside of file name by position or by referencing surrounding character s. Sort by entire line or by each word separated by a space. Only non-tag text content will remain. Text can be added to the end of the existing headers and fters, or the existing headers and fters can be replaced with new ones.

Alternatively, an existing header and fter can be replaced with a header and fter from another Word file. Word or higher required. Remove spaces and blank lines. Extract lines by the character s they contain or do not contain. Extract between starting and ending character s repeatedly throughout entire file s.

Save all extraction results as a file. Word Writer 2. Specify files to be joined and create a new Word file consisting of content from each file. Word files can be automatically backed up before hyperlink removal. Text in headers and fters are also replaced.

There is an option to find and replace multiple sets of words. Remove or replace character s. Remove spaces, enters and tabs. Remove alpha, numeric, alpha-numeric or non-alpha-numeric character s. Some Word files do not reduce as well as others.

Writer 2. Access XP or higher required. Find content differences between two tables in a database. Transfer tables to and from and databases. Change case in tables. Save tables as text or CSV files. Load one or many text files into a database. Vertically merge one Access table into another. Delete duplicate entries in tables. Extract email addresses in one or many databases. Transfer tables to and from and hypertext databases. Convert data in one table to a XML file. Apply math to fields columns in a table.

Extract entries that contain specific text in one or many databases. Extract all images from a database file. You can experiment with regular expressions and immediately see the results. Thanks Raymond. This text crawler will be great for my blog tools. Wish I found it earlier. See you around. Great tool, I trained as a Malware Removal expert and finding stuff in huge ComboFix, HJT, whatever logs is so time consuming that it almost drove me crazy.

Keep up the great work Raymond, you save people a lot of time and hassle, sincere thanks. Peter 19 hours ago. Mike 3 weeks ago. Mukesh 3 months ago. Juan Carlos 1 year ago. DOC format and the new. DOCX format. The modified code is pasted below. Feel free to use and improve!

It is being sent in multiple parts because comments to this site can only be characters or less. This code has saved so much time for me Is it possible to tweak this macro to perform multiple 'find and replace' stances at once? There are several words and phareses I need to replace and as of now I need to reinsert the VBA code for every instance. I'm a noob regarding those things. I've been testing it for the last few minutes and it's really a wonder, thank you!

I need to perform several 'find and replace' routines for several files. Dozens of routines for dozens of files. Is there a way to 'save' the module so I don't need to paste it again on the VBA screen every time I need to perform a new routine?

I am sorry but I have no idea re the headers or the format. It was not something I needed to include in my code. I had never used this before myself and the code I posted was taken from the original code above and then tweeked using code found in other searches until it worked.

I am sorry I cant be of more help. Thanks for posting this! I've run a couple tests and gotten it to work for me; however, it's not working on text in headers and footers for some reason. Is there a fix for this? Big THX 4 the code I want to change the format of the replaces text. How can it be achieved? Hello, This worked great for the word in the body of the document but did not replace the same word in the header. Any ideas. This worked perfectly and saved me so much time.

Thank you! It only runs across selected files and files must be in one folder only. This is run as a macro in a word doc. It is run from clicking a button. It only updates word doc's Hope this helps.

Count 'If the hyperlink matches. If LCase doc. Hyperlinks i. Save ActiveDocument. Count ' 'If the hyperlink matches. Save 'ActiveDocument. Close 'Next 'Application. Hi Pia, I am trying to run your script for replacing hyperlinks but am getting errors. Any chance you can post the script for replacing hyperlinks all in 1 piece?

I must be messing something up when trying to patch your code together. This is what finally worked for me. I hope it helps. I added this macro to a word file. It will run the replace any documents selected you can select as many as you like when the file dialoge is open. Extract data from text, html, xml and other files. Save to Excel and CSV. Learn more. Miltiple HTML file generator. Using just one csv-file with a database, you can create thousands of HTML pages.