Using Powershell to locate and update key value in a text file

Question

I have a text file (test.txt) containing the below:

User : MikeyMouse
Pswd : mycrazypswd
connectionstring : serverepor:80,pass=809hjhlkusfasdf,somepropert=somevalue

I need to use PS to update the above file's key value to mask passwords as shown below with "---"

sser : MikeyMouse
pswd : my---wd
connectionstring : serverepor:80,pass=80---df,somepropert=somevalue

Any suggestions on how bet to do that?

Thanks

Sage Pourpre · Accepted Answer · 2020-07-02 07:24:34Z

2

Using Get/Set-Content and a Regex -Replace will do the trick.

$Path = 'test.txt'
$NewContent = (Get-Content -Path $Path -Raw) -replace '(?<=Pswd : ..)(.*)(?=..\r)', '---' -replace '(?<=pass=..)(.*?)(?=..,)', '---' 
Set-Content -Path $Path -Value $NewContent

References:

.Net Regex cheat sheet

Special thanks

@olaf: For showing me the lookahead/lookbehind way.

edited Jul 2, 2020 at 7:24

answered Jul 2, 2020 at 5:52

Sage Pourpre

10.4k3 gold badges30 silver badges43 bronze badges

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

2 Comments

Ultra GC Over a year ago

Hi Sage... you are a life saver. This works for most part. For the "pass=" replace, your code return only "pass=80---" instead of "pass=80---df".

Sage Pourpre Over a year ago

@UltraGC Indeed. I fixed my answer.

Collectives™ on Stack Overflow

Using Powershell to locate and update key value in a text file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related