PRODAT PUBLIC



"---Starting---------------------------------------------------"

$reader      = [System.IO.File]::OpenText('C:\Temp\dumpall_xyz.sql')

$writer      = [System.IO.StreamWriter]   'C:\Temp\dumpall_Replaced.sql'

$searchFor   = ","        

$replaceWith = "?"      

[int]$count=0; [long]$bytes=0; $encoding = $null;

while($null -ne ($line = $reader.ReadLine())) {   

  $writer.WriteLine($line.replace($searchFor, $replaceWith));  

  if (!$encoding) { 

    $encoding = $reader.CurrentEncoding 

  } 

  $bytes += $encoding.GetByteCount($line)    

  $count++     

  if (($count % 10000) -eq 0) { 

    "Processed " + $count + " lines / " + [int] ( $bytes / 1048576) + " MB " 

  }

}

  # Zeile ausführen um Datei-Handle zu schließen, falls es Fehler gab.   

  $reader.Close(); $reader.Dispose(); $writer.Close(); $writer.Dispose();    

"---Done---------------------------------------------------"

"Processed " + $count + " lines / " + [int] ( $bytes / 1048576) + " MB " 

#Remove-Item  "D:\Test.tmp" -Force

#Rename-Item "$file.tmp" -NewName $filename