replace string in preceding line with value from next line

PowerShell Help
1

I need to use RegEx to find one string and replace it with a string in the following line.
Before:
SBRP18REMA~
NM1IL1DOEJANEAMI124111111800~
N3PO BOX 56~
After:
SBRP124111111800REMA~
NM1IL1DOEJANEAMI124111111800~
N3PO BOX 56~

$configFiles = Get-ChildItem -path "C:\test2\" *.DAT 
foreach ($file in $configFiles)
{
    (Get-Content $file.PSPath) |
    Foreach-Object { $_ -replace "SBR\*P\*?*","SBR\*P\*124111111800~} | set-Content $file.PSPath

I realize my RexEx is not even close.

thanks,
Kevin

2

http://regex101.com Note that the 2nd argument in -replace doesn’t use regex.

PS C:\users\admin> $a = 'SBR*P*18*RE******MA~'
PS C:\users\admin> $a -replace 'SBR\*P\*\d\d','SBR*P*124111111800'
SBR*P*124111111800*RE******MA~

Oh, it could be any number. Maybe this would help: Multi-line Regular Expression Replace in Powershell