Hi I would like to ask why my csv output still gets in a one or single cell.
here is the powershell script code:
$root = "C:\Users\devs"
$files = Get-ChildItem -Path $root -Filter *.txt
$data = ForEach ($file in $files){
Import-Csv -Path $file.Name
}
$data | Export-Csv -NoTypeInformation -UseCulture -Path (Join-Path $root "out.csv")
I want the output like this.