How to run PowerShell, as a Batch Process file txt/html with REGEX (search and replace)?

Question

hello. I have more regex to run on multiple html files from Folder1. I must run more REGEX with search and replace, for example:

SEARCH: (?-s)(".+?") REPLACE BY: $0
SEARCH: (^.*?)=(.*$) Replace by: \1\r\n\2
SEARCH: ^.(.*)$ REPLACE BY: \1

I mage a PowerShellp script, I add those 3 regex search and replace formulas, but is not working. Can anyone help me?

$sourceFiles = Get-ChildItem 'c:\Folder1'  
$destinationFolder = 'c:\Folder1'
foreach ($file in $sourceFiles) {
$sourceContent = Get-Content $file.FullName -Raw

$contentToInsert = [regex]::match($sourceContent,"(?-s)(".+?")").value
$destinationContent = Get-Content $destinationFolder\$($file.Name) -Raw
$destinationContent = $destinationContent -replace '$0',$contentToInsert

$contentToInsert = [regex]::match($sourceContent,"(^.*?)=(.*$)").value
$destinationContent = Get-Content $destinationFolder\$($file.Name) -Raw
$destinationContent = $destinationContent -replace '\1\r\n\2',$contentToInsert

$contentToInsert = [regex]::match($sourceContent,"^.(.*)$").value
$destinationContent = Get-Content $destinationFolder\$($file.Name) -Raw
$destinationContent = $destinationContent -replace '\1',$contentToInsert

Set-Content -Path $destinationFolder\$($file.Name) -Value $destinationContent -Encoding UTF8
} #end foreach file

Answer 1

got it. This is the solution:

$path = 'c:\Folder1\file1.html'
$result = 'c:\Folder1\result.html'
Get-Content -Path $path | ForEach-Object{ 
    $one = $_ -replace '(?<=<li>)\s+','CARPET' #replace First Regex with the word CARPET
    $two = $one -replace 'CARPET','DOOR' #replace the word CARPET with DOOR
    ($three = $two -replace 'DOOR','BEAUTIFUL') | Out-File -FilePath $result -Append #replace the word DOOR with BEAUTIFUL
    "Final = $three"
}

Answer 2

Hi @Suzana Eree ,

The two regexes don't work as neither '\K' nor '\h' is valid in powershell. To match the space you can use '\s' or the space character ' '.

$path = 'D:\temp\file.html'  
$result = 'D:\temp\result.html'  
Get-Content -Path $path | ForEach-Object{   
    ' ' + ($_ -replace '(?<=<li>)\s+','') + ' ' | Out-File -FilePath $result -Append       
    }  

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

thanks, @Ian Xue works, but as to understand much better the Batch process (multiple actions, one by one in order), I will give another example, with 4 simple regex that must run in order I give:

SEARCH: (?<=<li>)\s+ REPLACE BY: BEBE
SEARCH: BEBE REPLACE BY: OANA
SEARCH: OANA REPLACE BY: \s
SEARCH: <li>\s REPLACE BY: '' (by nothing, as to remove the space)

$path = 'c:\Folder1\file1.html'  
 $result = 'c:\Folder1\result.html'  
 Get-Content -Path $path | ForEach-Object{   
    ($_ -replace '(?<=<li>)\s+','BEBE') | Out-File -FilePath $result -Append    
    ($_ -replace 'BEBE','OANA')  | Out-File -FilePath $result -Append     
    ($_ -replace 'OANA','\s')  | Out-File -FilePath $result -Append   
    ($_ -replace '<li>\s','')  | Out-File -FilePath $result -Append   
         }  

It is not working. What did i do wrong?

Answer 4

The output of each replace operation is the string resulting from the replace. If we're to assume that the 1st regex put BEBE into the string you'd see that in output file. But for the 2nd, 3rd, and 4th regex you're operating on the original string (i.e. the on from your input file), not the resulting string from the 1sr regex. Because of that you won't find BEBE or OANA -- so the string from the file is sent to your output file. The 4th regex should work (if the 1st one did) so it should have erased the "<li> " and written the result to the output file.

If you want to see the progression of changes you'd have to operate on the result of the previous replace operation, not the original string.

Like this:

$one = "XXXX"
($two = $one -replace "XX$","xx") | Out-String
($three = $two -replace "^XX","aa") | Out-String
($four = $three -replace "ax","BB") | Out-String
"Final = $four"

Answer 5

thanks, @Rich Matheisen can you please write the entire code, also with $Path, $Result, Get content..etc, so as to ACCEPT it as a complete answer ?

also, if you can give some comments for other people that will view this post. For example *** XX will replace AA *** , *** ax will be replace by BB ***