Retrieve Values from text file and use them as Variable in PowerShell

Question

Please do not kill me as I am a newbie in Windows system administration ;) started few months ago and so I would kindly need a bit of help:

Basically , I would like to use values issued from a text file as variables: ($Clustername and $NewFSWPath) as described into the piece of PS code below:

$ClusterName = "GLA-CLU"
$NewFSWPath = "\\DC01\SQL-CLU"


#As quorum file share witness is a cluster core resource, the only way to remove an existing FSW in PS is to switch the cluster to node majority. It will remove the existing Cluster File Share Witness from the chosen cluster
Set-ClusterQuorum -Cluster $ClusterName -NodeMajority
#Set New Quorum File Share Witness for the cluster
#Add-ADGroupMember $FileShareSecurityGroup -Members "$ClusterName"
$t = $host.ui.RawUI.ForegroundColor
$host.ui.RawUI.ForegroundColor = "Yellow"
Write-Output "Setting A New Location for File Share Witness on cluster: '$($ClusterName)':"
Write-Host "`r"
$host.ui.RawUI.ForegroundColor = $t
Set-ClusterQuorum -Cluster $ClusterName -NodeAndFileShareMajority $NewFSWPath
Write-Host "`r"
$host.ui.RawUI.ForegroundColor = $t
$host.ui.RawUI.ForegroundColor = "Yellow"
Write-Output "Checking New File Share Witness Availablity:"
$host.ui.RawUI.ForegroundColor = $t
Get-clusterresource -cluster $ClusterName | where-object {$_.ResourceType -like "File Share Witness"} | get-clusterparameter

Much appreciated. Thank you.

What exactly is the question here? How to extract values from a text file? In that case, show the file and tell us what the values to extract are in there. — Theo
– Theo, Commented Nov 27, 2020 at 12:45
Hi, Thanks. What I need is to replace the values for variables (see the script I copied): $ClusterName = "GLA-CLU" >> Instead this value must be stored and retrieved from an existing text file $NewFSWPath = "\\DC01\SQL-CLU" >> same, Instead this value must be stored in a text file for example TEXT FILE will be: Clustername=GLA-CLU NewFSWPath=\\DC01\SQL-CLU — Willhem
– Willhem, Commented Nov 27, 2020 at 12:57
Then have a look at Get-Content, Add-Content and Set-Content — Theo
– Theo, Commented Nov 27, 2020 at 13:02

Willhem · Accepted Answer · 2020-11-27 18:48:56Z

1

Thanks, but I managed to sort it out using:

Get-Content 'fswsiteconf.txt' | Foreach-Object{
$var = $_.Split('=')
New-Variable -Name $var[0] -Value $var[1] }

It works for me now using the piece of code indicated above What do you think as a solution?

Thanks for your help.

answered Nov 27, 2020 at 18:48

Willhem

215 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

lww · Accepted Answer · 2020-11-27 16:23:19Z

0

Assuming your TEXT_FILE.TXT contains only two lines:

Clustername = GLA-CLU
NewFSWPath = \\DC01\SQL-CLU

then

$Path = "C:\TEXT_FILE.TXT"
$Lines = [System.IO.File]::ReadLines($Path)
$Token = $Lines.Split('=').Trim()
$ClusterName = $Token[1]
$NewFSWPath = $Token[3]

Write-Host $ClusterName
write-host $NewFSWPath

output:

GLA-CLU
\\DC01\SQL-CLU

now you can use your variables $ClusterName, $NewFSWPath in your script as required.

answered Nov 27, 2020 at 16:23

lww

6611 gold badge8 silver badges15 bronze badges

2 Comments

Willhem Over a year ago

Thanks. I managed to fix it, using: Get-Content 'fswsiteconf.txt' | Foreach-Object{ $var = $_.Split('=') New-Variable -Name $var[0] -Value $var[1] } it works this way. what do you think ?

lww Over a year ago

If it works and fulfils your requirements then that's it, you should use it. your question has solution in here -- > stackoverflow.com/questions/12368142/…

Collectives™ on Stack Overflow

Retrieve Values from text file and use them as Variable in PowerShell

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related