Matt Bloomfield

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

I recommend using regex101.com to test and build your regular expressions:

https://regex101.com/

It’s not clear if you want the RequestId and Order in the same string or not?

PowerShell

<requestId>\w{6}-\w{6}-\w{6}.+Order:\s\w{6}-\w{6}-\w{6}

1	<requestId>\w{6}-\w{6}-\w{6}.+Order:\s\w{6}-\w{6}-\w{6}

Would match the whole string up to the end of the order number.

PowerShell

(Order:\s\w{6}-\w{6}-\w{6})

1	(Order:\s\w{6}-\w{6}-\w{6})

Would match just the order portion.

For the users, you just need to find a regular expression that matches your examples.

PowerShell

User.\d+

1

User.\d+

Would match User, followed by any character, followed by 1 or more digits.

 

 

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

You could try Select-String which is usually faster than Get-Content:

PowerShell

(Select-String -Path .\test.txt -Pattern $strings -NotMatch).Line | Set-Content .\file2.txt

1	(Select-String -Path .\test.txt -Pattern $strings -NotMatch).Line | Set-Content .\file2.txt

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

If it’s only two columns, you could import the CSV into a hashtable and see if the key (column 1) already exists, if it does, add it to existing key (hashtables can’t contain duplicate keys).

 

PowerShell

$data = @" col1,col2 ab,data1 cd,data2 ef,data1 ab,data2 cd,data3 "@ $csv = ConvertFrom-Csv $data $HashTable = @{} foreach($row in $csv) { if ($row.col1 -in $hashTable.Keys) { $hashTable[$row.col1] = $hashTable[$row.col1] + " | $($row.col2)" } else { $hashTable[$row.col1] = $row.col2 } } $hashTable Output: Name Value ---- ----- cd data2 | data3 ef data1 ab data1 | data2

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

$data = @" col1,col2 ab,data1 cd,data2 ef,data1 ab,data2 cd,data3 "@   $csv = ConvertFrom-Csv $data   $HashTable = @{}   foreach($row in $csv) {       if ($row.col1 -in $hashTable.Keys) {              $hashTable[$row.col1] = $hashTable[$row.col1] + " | $($row.col2)"          }       else {           $hashTable[$row.col1] = $row.col2       }      }   $hashTable       Output:   Name                           Value ----                           ----- cd                             data2 | data3 ef                             data1 ab                             data1 | data2

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

Windows Terminal is what you’re after.  Unicode support and much, much more besides:

Introducing Windows Terminal

https://aka.ms/terminal

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

For sure.  Just add the variable at the top of the script:

PowerShell

$export = $true #change to $false to turn off exporting

1	$export = $true #change to $false to turn off exporting

Then modify the export section:

PowerShell

if ($export) {     [PSCustomObject] @{         'Replacement Value' = $replace         'Original Value'    = $find     } | Export-csv $changeLog -NoTypeInformation -Append -NoClobber }

1 2 3 4 5 6 7 8

if ($export) {       [PSCustomObject] @{         'Replacement Value' = $replace         'Original Value'    = $find     } | Export-csv $changeLog -NoTypeInformation -Append -NoClobber   }

 

 

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

Just a case of looping over the files in $FileBrowser.FileNames

 

PowerShell

$wordtochange = New-TemporaryFile @' Anna:Annamaria Sugar:Agave Android:Phone '@ | Set-Content $wordtochange Add-Type -AssemblyName System.Windows.Forms $fileBrowser = New-Object System.Windows.Forms.OpenFileDialog -Property @{Multiselect = $true} $null = $fileBrowser.ShowDialog() if ($fileBrowser.FileNames) { foreach ($file in $fileBrowser.FileNames) { $textchange = Get-Content $file -Raw Get-Content $wordtochange | foreach { $find,$replace = $_ -split ':' $textchange = $textchange -creplace "\b$find(?=\W)\b",$replace } $textchange | Set-Content $file #Warning: this overwrites the original file. } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

$wordtochange = New-TemporaryFile @' Anna:Annamaria Sugar:Agave Android:Phone '@ | Set-Content $wordtochange   Add-Type -AssemblyName System.Windows.Forms $fileBrowser = New-Object System.Windows.Forms.OpenFileDialog -Property @{Multiselect = $true} $null = $fileBrowser.ShowDialog()   if ($fileBrowser.FileNames) {       foreach ($file in $fileBrowser.FileNames) {           $textchange = Get-Content $file -Raw           Get-Content $wordtochange | foreach {             $find,$replace = $_ -split ':'             $textchange = $textchange -creplace "\b$find(?=\W)\b",$replace                  }           $textchange | Set-Content $file #Warning: this overwrites the original file.          }   }

 

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

Specify the same domain controller with the -Server parameter for both cmdlets.  You’re probably hitting a different DC when you run Set-ADAccountExpiration and the new account hasn’t replicated.

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

It’s \b \b to set the boundary, not /b /b.

That works OK for me:

PowerShell

$textchange = $textchange -creplace "\b$find(?=\W)\b",$replace

1	$textchange = $textchange -creplace "\b$find(?=\W)\b",$replace

[Matt Bloomfield]

In that case, I would match the tag as well then use multiple counters:

PowerShell

$log = 'E:\Temp\log.txt' $changeLog = 'E:\Temp\ChangeLog.csv' @' <requestId>qwerty-qwer12-qwer56</requestId>Ace of Base Order: Q2we45-Uj87f6-gh65De<something else... <requestId>zxcvbn-zxcv12-zxcv56</requestId> <requestId>1234qw-12qw12-123456</requestId> Stevie Wonder <messageId>1234qw-12qw12-123456</msg <reportId>plmkjh8765FGH4rt6As</msg:reportId>something here.,. <requestId>zxcvbn-zxcv12-zxcv56</requestId> <reportId>poGd56Hnm9q3Dfer6Jh</msg:reportId> uraaa 123 <keyID>poU6Ghk89edfTG78Jk45GrRt23HzW4pl</msgdc '@ | Set-Content $log -Encoding UTF8 $tmp = Get-Content $log -Raw $results = $tmp | Select-String -Pattern '(<ReportId>\w{19})|(<RequestId>\w{6}-\w{6}-\w{6})|(<KeyID>\w{32})' -AllMatches | Select-Object -ExpandProperty Matches | Select-Object -ExpandProperty Value | Select-Object -Unique $reportCount = 1 $requestCount = 1 $keyCount = 1 foreach ($result in $results) { if ($result -like '<ReportId>*') { $find = ($result -replace '<ReportId>') $replace = "ReportID-$reportCount" $tmp = $tmp -replace $find,$replace $reportCount++ } if ($result -like '<RequestId>*') { $find = ($result -replace '<RequestId>') $replace = "RequestID-$requestCount" $tmp = $tmp -replace $find,$replace $requestCount++ } if ($result -like '<KeyID>*') { $find = ($result -replace '<KeyID>') $replace = "KeyID-$keyCount" $tmp = $tmp -replace $find,$replace $keyCount++ } [PSCustomObject] @{ 'Replacement Value' = $replace 'Original Value' = $find } | Export-csv $changeLog -NoTypeInformation -Append -NoClobber } $tmp | Set-Content $log -Encoding UTF8

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

$log = 'E:\Temp\log.txt' $changeLog = 'E:\Temp\ChangeLog.csv' @' <requestId>qwerty-qwer12-qwer56</requestId>Ace of Base Order: Q2we45-Uj87f6-gh65De<something else... <requestId>zxcvbn-zxcv12-zxcv56</requestId> <requestId>1234qw-12qw12-123456</requestId> Stevie Wonder <messageId>1234qw-12qw12-123456</msg <reportId>plmkjh8765FGH4rt6As</msg:reportId>something here.,. <requestId>zxcvbn-zxcv12-zxcv56</requestId> <reportId>poGd56Hnm9q3Dfer6Jh</msg:reportId> uraaa 123 <keyID>poU6Ghk89edfTG78Jk45GrRt23HzW4pl</msgdc '@ | Set-Content $log -Encoding UTF8 $tmp = Get-Content $log -Raw $results = $tmp |     Select-String -Pattern '(<ReportId>\w{19})|(<RequestId>\w{6}-\w{6}-\w{6})|(<KeyID>\w{32})' -AllMatches |         Select-Object -ExpandProperty Matches | Select-Object -ExpandProperty Value | Select-Object -Unique $reportCount  = 1 $requestCount = 1 $keyCount     = 1   foreach ($result in $results) {     if ($result -like '<ReportId>*') {           $find = ($result -replace '<ReportId>')         $replace = "ReportID-$reportCount"         $tmp = $tmp -replace $find,$replace         $reportCount++       }       if ($result -like '<RequestId>*') {           $find = ($result -replace '<RequestId>')         $replace = "RequestID-$requestCount"         $tmp = $tmp -replace $find,$replace         $requestCount++       }          if ($result -like '<KeyID>*') {           $find = ($result -replace '<KeyID>')         $replace = "KeyID-$keyCount"         $tmp = $tmp -replace $find,$replace         $keyCount++       }       [PSCustomObject] @{         'Replacement Value' = $replace         'Original Value'    = $find     } | Export-csv $changeLog -NoTypeInformation -Append -NoClobber } $tmp | Set-Content $log -Encoding UTF8

 

• This reply was modified 1 month, 2 weeks ago by Matt Bloomfield. Reason: Reformatted a long line for readability

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

Select-String should accept an array of strings for the Pattern, although that didn’t seem to work.  However, you can put two patterns in the regex which is what I’ve done.

I also added a Select-Object -Unique so that the count matches the replacement value if there’s more than one of the same value.

To keep the changes, I opted to use a custom object and export it to a CSV file as it’s easy to read.

PowerShell

$log = 'E:\Temp\log.txt' $changeLog = 'E:\Temp\ChangeLog.csv' @' <requestId>qwerty-qwer12-qwer56</requestId>Ace of Base Order: Q2we45-Uj87f6-gh65De<something else... <requestId>zxcvbn-zxcv12-zxcv56</requestId> <requestId>1234qw-12qw12-123456</requestId> Stevie Wonder <messageId>1234qw-12qw12-123456</msg <reportId>plmkjh8765FGH4rt6As</msg:reportId>something here.,. <requestId>zxcvbn-zxcv12-zxcv56</requestId> reportId>poGd56Hnm9q3Dfer6Jh</msg:reportId> uraaa 123 <keyID>poU6Ghk89edfTG78Jk45GrRt23HzW4pl</msgdc '@ | Set-Content $log -Encoding UTF8 $tmp = Get-Content $log -Raw $results = $tmp | Select-String -Pattern '(\w{6}-\w{6}-\w{6})|(<keyID>\w{32})' -AllMatches | Select-Object -ExpandProperty Matches | Select-Object -ExpandProperty Value | Select-Object -Unique $count = 1 foreach ($result in $results) { $tmp = $tmp -replace $result,"Replace-$count" [PSCustomObject] @{ 'Replacement Value' = "Replace-$count" 'Original Value' = $result } | Export-csv $changeLog -NoTypeInformation -Append -NoClobber $count++ } $tmp | Set-Content $log -Encoding UTF8

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

$log = 'E:\Temp\log.txt' $changeLog = 'E:\Temp\ChangeLog.csv' @' <requestId>qwerty-qwer12-qwer56</requestId>Ace of Base Order: Q2we45-Uj87f6-gh65De<something else... <requestId>zxcvbn-zxcv12-zxcv56</requestId> <requestId>1234qw-12qw12-123456</requestId> Stevie Wonder <messageId>1234qw-12qw12-123456</msg <reportId>plmkjh8765FGH4rt6As</msg:reportId>something here.,. <requestId>zxcvbn-zxcv12-zxcv56</requestId> reportId>poGd56Hnm9q3Dfer6Jh</msg:reportId> uraaa 123 <keyID>poU6Ghk89edfTG78Jk45GrRt23HzW4pl</msgdc '@ | Set-Content $log -Encoding UTF8 $tmp = Get-Content $log -Raw $results = $tmp | Select-String -Pattern '(\w{6}-\w{6}-\w{6})|(<keyID>\w{32})' -AllMatches | Select-Object -ExpandProperty Matches | Select-Object -ExpandProperty Value | Select-Object -Unique $count = 1 foreach ($result in $results) {     $tmp = $tmp -replace $result,"Replace-$count"     [PSCustomObject] @{         'Replacement Value' = "Replace-$count"         'Original Value'    = $result     } | Export-csv $changeLog -NoTypeInformation -Append -NoClobber     $count++ } $tmp | Set-Content $log -Encoding UTF8

 

[Matt Bloomfield]

Can be done on one line but I’ve split it at the | for readability on the forum.

PowerShell

Get-Content E:\Temp\dictionary.txt | foreach {$_ -replace $_,(($_ -split ':')[1,0] -join ':') | Out-File E:\Temp\reversedDictionary.txt -Append}

1 2 3

Get-Content E:\Temp\dictionary.txt |     foreach {$_ -replace $_,(($_ -split ':')[1,0] -join ':') |         Out-File E:\Temp\reversedDictionary.txt -Append}

 

• This reply was modified 1 month, 2 weeks ago by Matt Bloomfield. Reason: Formatting

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

Thanks for reformatting, it’s working OK now.

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

PowerShell

$log = 'E:\Temp\log.txt' @' <requestId>qwerty-qwer12-qwer56</requestId>Ace of Base Order: Q2we45-Uj87f6-gh65De<something else... <requestId>zxcvbn-zxcv12-zxcv56</requestId> <requestId>1234qw-12qw12-123456</requestId> Stevie Wonder <messageId>1234qw-12qw12-123456</msg '@ | Set-Content $log -Encoding UTF8 $tmp = Get-Content $log -Raw $results = $tmp | Select-String '\w{6}-\w{6}-\w{6}' -AllMatches | Select-Object -ExpandProperty Matches | Select-Object -ExpandProperty Value $count = 1 foreach ($result in $results) { $tmp = $tmp -replace $result,"Replace-$count" $count++ } $tmp | Set-Content $log -Encoding UTF8

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

$log = 'E:\Temp\log.txt'   @' <requestId>qwerty-qwer12-qwer56</requestId>Ace of Base Order: Q2we45-Uj87f6-gh65De<something else... <requestId>zxcvbn-zxcv12-zxcv56</requestId> <requestId>1234qw-12qw12-123456</requestId> Stevie Wonder <messageId>1234qw-12qw12-123456</msg '@ | Set-Content $log -Encoding UTF8   $tmp = Get-Content $log -Raw   $results = $tmp | Select-String '\w{6}-\w{6}-\w{6}' -AllMatches | Select-Object -ExpandProperty Matches | Select-Object -ExpandProperty Value   $count = 1   foreach ($result in $results) {       $tmp = $tmp -replace $result,"Replace-$count"     $count++   }   $tmp | Set-Content $log -Encoding UTF8

 

[Matt Bloomfield]

-contains is for checking if a collection contains a object, it’s not meant for string comparisons.  Try changing your statement to

if ($user -notlike ‘*.adm’) {}

Looks like your variables are mixed up in the else statement too.

• This reply was modified 1 month, 2 weeks ago by Matt Bloomfield. Reason: Added a missing word
• This reply was modified 1 month, 2 weeks ago by Matt Bloomfield. Reason: Changed a word for clarity

[Matt Bloomfield Participant Topics: 4 Replies: 429 Points: 770Rank: Major Contributor]

If the button is missing, you can either switch to Text view and use the CRAYON button or refresh the page a few times.  Usually after two or three refreshes the <> comes back for me.

[Author]

Posts