Export and Import VM Multi line notes

[ganapa2000]

Hi,

I am trying to export multiple lines notes from VM, using the below, I am able to get only first line, please help

Get-VM | Select Name,Notes | Export-Csv -Path ".\VMNotes0.csv" -NoTypeInformation

[LucD · Accepted solution]

The problem is with Export-Csv, which can't handle this correctly.
One way to solve is to, for example, replace the NewLine with a blank

Get-VM |

Select Name, @{N='Notes';E={$_.Notes.replace("`n",' ')}} |

Export-Csv -Path ".\VMNotes0.csv" -NoTypeInformation

---------------------------------------------------------------------------------------------------------

Was it helpful? Let us know by completing this short survey here.

[ganapa2000]

Got it LucD, that worked

[NAV4UK]

The below will list the Powered Off VMs with Notes

Get-VM | where {$_.powerstate -match "off"} | Select Name, @{N='Notes';E={$_.Notes.replace("`n",' ')}} | FT -autosize