How to extract to single cell value in multiple columns in csv through powershell

1
votes

I have below Value in A1 cell:

A;"B";"C";"D";"E";"F";"G"

I want to split to next column header like as below:

A B C D E F G

Note: A B C D E F G this is individual column header.

I'm using below powershell command but no luck:

$CSVpath = "D:\test.csv"
$data = import-csv $CSVpath
$b=$data[0].psobject.properties.name | Out-File 
$b = $b -split ';'
write-host $b 
$csvRows | Export-Csv -NoTypeInformation -Encoding utf8 $CSVpath

P.S. I wanna make dynamic script instead of static.

powershellcsv