powershell - Remove New Line Character from CSV file's string column

Question

I have a CSV File with a string column were that column spans to multiple lines. I want to aggregate those multiple lines into one line.

For example

1, "asdsdsdsds", "John"
2, "dfdhifdkinf
dfjdfgkdnjgknkdjgndkng
dkfdkjfnjdnf", "Roy"
3, "dfjfdkgjfgn", "Rahul"

I want my output to be

1, "asdsdsdsds", "John"
2, "dfdhifdkinf dfjdfgkdnjgknkdjgndkng dkfdkjfnjdnf", "Roy"
3, "dfjfdkgjfgn", "Rahul"

I want to achieve this output using PowerShell

Thanks.

Answer 1

Building on Ansgar's answer, here's how to do it when:

• You don't know the column names

• Your CSV file may contain CR or LF independently

  (Import-Csv $csvInput) | % {
      $line = $_
      foreach ($prop in $line.PSObject.Properties) {
          $line.($prop.Name) = ($prop.Value -replace '[
  ]',' ')
      }
      $line
  } | Export-Csv $csvOutput -NoTypeInformation