Text manipulation in PowerShell

[excelos]

Hello

I am looking for a free and fast way to manipulate large amounts of data (GigaBytes).

I think Powershell is the most appropriate as it comes with Windows and it is fast. Do you have any other alternatives?

As for Powershell, can you help me please with a script that will read the lines of a document and for each line, it will delete the text outside a specific regex?

I am not sure how to structure such script, which commands to use etc.

Thanks!

 

[excelos]

Anyone?

 

[kennypete]

Notwithstanding you had no takers for your question or follow-up (but at the time of posting have had 575 views[!]), this may be far too late...

This script, as an example, will ignore any line that does not have "Powershell" appearing in it (-like "*Powershell*") from all files with the extension .txt in the directory where the script is residing, naming the output files with the extension .out.txt

$files = Get-ChildItem -Path $PSScriptRoot -Recurse -Include *.txt
foreach ($file in $files){
    $outfile = $file.DirectoryName + "\" + $file.BaseName + ".out.txt"
    $strREGEX = "*Powershell*"
    $strOutput = ""
    foreach($Line in Get-Content $file) {
        If ($Line -like $strREGEX) {
            $strOutput = $strOutput + $Line + [environment]::NewLine
        }
    }
    $strOutput | Out-File -FilePath $outfile
}

Is that the sort of thing that you are/were after?