Powershell change output object name from datatable

Question

I'm outputting a couple of objects from a data table to a .csv file and wanted to change the object names.

This works fine:

$dataset.tables[0] | select-object System.ItemName, System.ItemPathDisplay | Export-Csv -Path D:\SEARCH_RESULT.csv -NoTypeInformation

However I'd like to change System.ItemName to SKU and have tried the following:

$dataset.tables[0] | select-object @{N='SKU';E={$_.System.ItemName}}, System.ItemPathDisplay | Export-Csv -Path D:\SEARCH_RESULT.csv -NoTypeInformation

This gives the right column heading but blank rows. So tried this which give rows but they all say SYSTEM.ITEMNAME:

$dataset.tables[0] | select-object @{N='SKU';E={$dataset.tables[0].Columns['SYSTEM.ITEMNAME']}}, System.ItemPathDisplay | Export-Csv -Path D:\SEARCH_RESULT.csv -NoTypeInformation

Clearly I'm not referencing the object correctly. Any help greatly appreciated.

mklement0 · Accepted Answer · 2022-03-23 21:45:56Z

1

Change $_.System.ItemName to $_.'System.ItemName'

Your property name is System.ItemName, and if a property name itself contains ., it must be quoted - otherwise, PowerShell interprets it as a nested property access

That is, $_.System.ItemName looks for a property on object $_ named System first, and then for an ItemName property on the first property's value; PowerShell defaults to $null when accessing non-existent properties.

Contrast this with the use of System.ItemName as an argument passed to the (positionally implied) -Property parameter of the Select-Object cmdlet, where the argument is always interpreted as a single property name (whether you quote it or not).
In other words: Select-Object doesn't directly support nested property access, but you can do it via a calculated property, as in your approach.

edited Mar 23, 2022 at 21:45

answered Mar 23, 2022 at 17:20

mklement0

452k68 gold badges727 silver badges986 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ColinA Over a year ago

Thanks very much for the explanation. Much appreciated!

Collectives™ on Stack Overflow

Powershell change output object name from datatable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related