How to search for a string and replace entire line using powershell? (If string NOT matched, need to create a new line with the content)

Question

Sample.txt:

SQL.test = True
wer.vul = 1
temp_RTE = False
user_admin = no

In the above text file, I want to search for a string "test" and replace entire line with "SQL.test = False" using Windows Powershell script. If "test" text is not matched, need to add "SQL.test = False" line to that file.

I have tried this. But I am unable to solve.

Please guide me how to achieve this.

Micky Balladelli · Accepted Answer · 2016-08-22 15:27:21Z

1

One way to do it is as follows:

$text = 'test'
$found = $false
$infile = '.\a.txt'
$outfile = '.\b.txt'
Get-Content -Path $infile | % { 
    if ($_ -match $text)
    {
        $found = $true
        "SQL.test = False"
    }
    else
    {
        $_
    }
} | Out-File -filepath $outfile
if (!$found)
{
    "SQL.test = False" |Out-File -filepath $outfile -Append
}

This can be optimized further, I'm sure.

Basically what this does is use Get-Content to retrieve each line in the text file, and pipe them to Select-String. If the text is found, the line is changed, if not, the original line is returned. If the text is not found, then it's appended.

If the text is found the output is:

SQL.test = False
wer.vul = 1 
temp_RTE = False 
user_admin = no

else

wer.vul = 1 
temp_RTE = False 
user_admin = no 
SQL.test = False

edited Aug 22, 2016 at 15:27

answered Aug 22, 2016 at 13:01

Micky Balladelli

10k2 gold badges36 silver badges31 bronze badges

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

1 Comment

rcubefather Over a year ago

Thanks for your answer. If i run this code, its replacing entire content with the text. I want to 1. If text found replace the entire line (remaining lines should be present). 2. If text not found, should append the text. Please give any clue to fix this.

blabb · Accepted Answer · 2016-08-22 13:16:00Z

0

$c = gc .\test.txt
$c | %{ if ( $_ -match "test") { "SQL.test = False" } else {"SQL.test = True"} }

will output

SQL.test = False
SQL.test = True
SQL.test = True
SQL.test = True

for input file

SQL.test = True
wer.vul = 1
temp_RTE = False
user_admin = no

if you meant add "sqlxxxx" to that line simply use the concat + operator

$c | %{ if ( $_ -match "test") { "SQL.test = False" } else {$_ + " SQL.test = True"} }

will output

SQL.test = False
wer.vul = 1 SQL.test = True
temp_RTE = False SQL.test = True
user_admin = no SQL.test = True

edited Aug 22, 2016 at 13:16

answered Aug 22, 2016 at 13:10

blabb

9,1121 gold badge20 silver badges29 bronze badges

Comments

autosvet · Accepted Answer · 2016-08-22 13:41:24Z

0

I think that this should work for you :)

# Get content from the original file
$TXT = Get-Content "C:\temp\New Text Document.txt"
#Path to new file
$NewTXT="C:\temp\newTxt.txt"
$i=0
$TXT|ForEach-Object {
    if ($_ -match "test")
        {($_ -replace $_,"SQL.test = False") | Out-File $NewTXT -Append
        $i++ #increment}
      else
        {$_ | Out-File $NewTXT -Append}
}

If ($i -eq 0) #if $i=0 no "test" found, need to add new line "SQL.test = False"
    {"SQL.test = False" | Out-File $NewTXT -Append}

answered Aug 22, 2016 at 13:41

autosvet

8801 gold badge9 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to search for a string and replace entire line using powershell? (If string NOT matched, need to create a new line with the content)

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related