title: Set custom row delimiter using batch/powershell script
body: <p>I have a big file >1.5GB, and it has '#@#@#' as row delimiter. I will replace this with a CRLF character before I process it through Informatica. The issue is, I have CR ,LF characters in the file, and I need to get rid of them before the replacement. I have found couple options to do that, but due to the size, I get OutofMemory exceptions.</p>
  
  <pre><code>param
  (
    [string]$Source,
    [string]$Destination
  )
  
  echo $Source
  echo $Destination
  
  $Writer = New-Object IO.StreamWriter $Destination
  $Writer.Write( [String]::Join("", $(Get-Content $Source)) )
  $Writer.Close()
  </code></pre>
  
  <p>My question is, is there anyway to set my row delimiter as '#@#@#' and then read the file line by line to remove CR,LF characters.</p>