Hi all,
I'm creating a PowerShell script and am attempting to use;
"$variable1,$variable2,$variable3" | Add-Content -Path "file.csv" -Encoding UTF8
The variables echo/write-host as;
Variable1
Hello
Variable2
World
Variable3
Hello
World
My issue is that the Add-Content above should create a CSV file like this;
Hello,World,Hello World
But it doesn't. Instead, it creates;
Hello,World,Hello
World
How can I go about using Add-Content to export to CSV, but get it to ignore new lines?
Opened in Excel, I want 'cell' C1 to b