Seems silly, yes, but that’s the way the FileSystemObject works: you can open a file for reading or you can open a file for writing, but you can’t perform both operations at the same time. We then close C:\Scripts\Text.txt even though we’ll almost immediately reopen it, this time for writing. With the file open, we use the ReadAll method to read the contents of the entire file into the variable strText. We create an instance of the FileSystemObject, and then use the OpenTextFile method to open the file C:\Scripts\Text.txt for reading. We start off by creating two constants ( ForReading and ForWriting), which we’ll use for the two occasions when we’ll open our text file. Set objFile = objFSO.OpenTextFile(“C:\Scripts\Text.txt”, ForWriting) StrNewText = Replace(strText, “Jim “, “James “) Set objFile = objFSO.OpenTextFile(“C:\Scripts\Text.txt”, ForReading) Set objFSO = CreateObject(“Scripting.FileSystemObject”)
Instead, let’s start with a simple script that carries out the search and replace: Const ForReading = 1 We can even do all that from the command line, although we’ll hold off on that for a moment. We can: 1) open up a text file 2) read the text into a variable 3) do a search-and-replace on that variable and 4) re-save the text file. Fortunately, this problem is typical of text file questions in one other respect: although there’s no obvious way to carry out the task, we can still find a way to get the job done.Īlthough we can’t directly search and replace text inside a text file, we can do the next best thing. As we’ve found out numerous times when dealing with text files, there is no obvious way to do this that is, there is no ReplaceText command that can open a text file and find and replace text.
Hey, Scripting Guy! From the command line, how can I use a script to open a file and replace text for example, how can I replace all instances of “Jim” with “James”?
0 kommentar(er)
