Open And Close .txt File With A Search And Replace

**ajocius** · 01-28-2018, 01:01 PM

I have multiple .txt files which I get as data files. Inside these files there are two types of character sequences which I would like to delete. The first is: < lots of text > and the second is: < lots of text>, . The <> has all sorts of formatting stuff not relevant to my needs. I want to delete all references to these character groups. Note the comma shown on the second character string after the >. How can I open a text file from inside Word without actually displaying the data and removing these formatting < > / < >, strings? I would like to do this in VBA for Word. Lastly I'd like to Save the File as a .txt but with the word "Modified" tacked on to the beginning of the file name. Your assistance would be amazing. Thank you in advance.

Tony

**6StringJazzer** · 01-28-2018, 01:51 PM

Please attach one sample of this file for test purposes.

Are you looking for all occurrences of any text that occurs inside "<>" or "<>,"?

What do you mean by this: "without actually displaying the data"? It is possible to open a Word file from VBA without showing the application on the screen. Is that what you mean?

**MrShorty** · 01-28-2018, 02:00 PM

Is it necessary to use Word? I use Notepad++ (a free open source text/code editor) for a few text operations, and one of the available commands is "Find and replace in files". I'm sure there are other text editors with similar commands. It might be possible to find a text editor with the built in ability to find and replace the desired text in your files without needing to write your own code to do it.