Script to add the contents clipboard on a particular line of ini file

phrab · 30 May 2020

ddelo said:

Copy and paste the following three lines of code into a text file.
In the 1st line replace within the quotes the path of your .ini file.
Save the text file with an extension ps1, for example Test.ps1

Code:

$INIFile = "C:\Users\<UserName>\Desktop\OOreg.ini"
$LastAddressFromClipboard = Get-Clipboard -Format Text -TextFormatType UnicodeText
(Get-Content $INIFile | ForEach-Object { $_ -replace "LastAddress=.+", "LastAddress=$LastAddressFromClipboard" }) | Set-Content $INIFile

Copy to the clipboard the address you want to save in your .ini file
Open File Explorer and go to the folder where you saved the Test.ps1 file.
In File Explorer select File > Open Windows PowerShell (either as user or Administrator, I prefer Administrator)
In the PowerShell console window type .\Test.ps1

That's it!

Thank you for this. I will try it out. In the meantime, I was able to learn how to do this with Autohotkey. My script is:

IniWrite, %Clipboard%, C:\Utilities\RegEditor\OORegEdt.INI, Settings, LastAddress

Run, C:\Utilities\RegEditor\OORegEdt.exe

- - - Updated - - -

KeithM said:

PowerShell:

Code:

$IniFile = 'c:\Path\To\file.ini'
$NewText = gcb
(gc $IniFile -Raw) -replace '(?<=LastAddress=).+(?=\n)', $NewText

Thank you, Keith. I appreciate your advice & will experiment with it.

ddelo · 30 May 2020

phrab said:

Thank you for this. I will try it out. In the meantime, I was able to learn how to do this with Autohotkey.

Most welcome Phil. I hope you get it working the way you want.

KeithM · 30 May 2020

phrab said:

Thank you, Keith. I appreciate your advice & will experiment with it.

I forgot Set-Content (sc) after replace. I've edited my reply.

Matthew Wai · 31 May 2020

KeithM said:

PowerShell:

Code:

$IniFile = 'c:\Path\To\file.ini'
$NewText = gcb
(gc $IniFile -Raw) -replace '(?<=LastAddress=).+(?=\n)', $NewText | sc $iniFile

It works with an .ini file. How can I make it work with other files, e.g. a .txt file?

ddelo · 31 May 2020

Matthew Wai said:

It works with an .ini file. How can I make it work with other files, e.g. a .txt file?

Change the filename in the first line to $IniFile = 'c:\Path\To\file.txt'

Matthew Wai · 31 May 2020

It works now. Thank you!

ddelo · 31 May 2020

Try this then:

Code:

$MyFile = "C:\Users\<UserName>\Desktop\somefile.txt"
$LastAddressFromClipboard = Get-Clipboard -Format Text -TextFormatType UnicodeText
(Get-Content $MyFile | ForEach-Object { $_ -replace "LastAddress=.+", "LastAddress=$LastAddressFromClipboard" }) | Set-Content $MyFile

Matthew Wai · 31 May 2020

@ddelo,

Code:

$MyFile = "E:\Testing\somefile.txt"
$LastAddressFromClipboard = Get-Clipboard -Format Text -TextFormatType UnicodeText
(Get-Content $MyFile | ForEach-Object { $_ -replace "ABCD=.+", "ABCD=$LastAddressFromClipboard" }) | Set-Content $MyFile

I put the above code into a .ps1 file, copied some text into the clipboard and then right-clicked on the file-->"Run with PowerShell". The following "E:\Testing\somefile.txt" remained unchanged.

Code:

Microsoft Windows [Version 10.0.18362.30]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\Windows\system32>More "E:\Testing\somefile.txt"
ABCD=

C:\Windows\system32>

Do you know what is wrong?

KeithM · 31 May 2020

Matthew Wai said:

@ddelo,

Code:

$MyFile = "E:\Testing\somefile.txt"
$LastAddressFromClipboard = Get-Clipboard -Format Text -TextFormatType UnicodeText
(Get-Content $MyFile | ForEach-Object { $_ -replace "ABCD=.+", "ABCD=$LastAddressFromClipboard" }) | Set-Content $MyFile

I put the above code into a .ps1 file, copied some text into the clipboard and then right-clicked on the file-->"Run with PowerShell". The following "E:\Testing\somefile.txt" remained unchanged.

Code:

Microsoft Windows [Version 10.0.18362.30]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\Windows\system32>More "E:\Testing\somefile.txt"
ABCD=

C:\Windows\system32>

Do you know what is wrong?

Did you have at least one character aftter the = character in your target file? That's what the .+ matches in a regex. To allow for no characters after the =, use: -replace "ABCD=.*"

Matthew Wai · 31 May 2020

Thank you! You are right.