Read from Text File and Replace String using Powershell
For now , I have this command below that works fine when I run it against one remote computer named Windows7 and Replacing one string "username" with "white"
but when I have many computers, then it does not help
((Get-Content -Path '\\Windows7\c$\test.txt' -Raw) -replace ' username', ' white') | Set-Content -Path '\\Windows7\C$\test.txt'
I will have to put in a separate Text file like this:
Windows7 White
PCNT34 JDOck
FRANKIST Ballon
...
the first column is the remote computer name and the second column is the string that will replace the second username.
As I stated , the command I pasted above works just fine, it needs to read from a separate text file so that the command will apply to several computers listed on the text file.
Thank you
ASKER
ComputerName NewUserName
Windows7 White
W12 Brown
when I run it I get these errors:
You cannot call a method on a null-valued expression.
At C:\Scripts\changestring.ps1:11 char:2
+ $computer = $_.ComputerName.Trim()
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull
You cannot call a method on a null-valued expression.
At C:\Scripts\changestring.ps1:12 char:2
+ $newUser = $_.NewUsername.Trim()
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull
Processing , new user '' ... FAILED: Cannot find path '\\\C$\test.txt' because it does not exist.
You cannot call a method on a null-valued expression.
At C:\Scripts\changestring.ps1:11 char:2
+ $computer = $_.ComputerName.Trim()
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull
You cannot call a method on a null-valued expression.
At C:\Scripts\changestring.ps1:12 char:2
+ $newUser = $_.NewUsername.Trim()
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull
Then add the -Delimiter argument to Import-Csv i line 7
Import-Csv -Path $csv -Delimiter "<Delimiter here>" | ForEach-Object {
ASKER
I just created text file with Notepad that includes:
ComputerName,NewUserName
Windows7,White
W12,Brown
Saved it as .CSV
I ran the script and it did the change on remote computers.
Thank you very much for your Help.
ASKER
Thank you
A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.
TRUSTED BY
Just save it an Excel as file type "Csv".