Powershell formatting imported XML as a datatable

Question

I am using Powershell to import an XML file and I would like to format the data as a datatable.

Using the question below I can view the data as a table in the powershell console.

The powershell I produced from this question is shown below.

$peakPrices = $dt.heml.Transactions.Record | format-table -AutoSize -Property @{Label="Period";Expression={$_.column[0]."#text"}},
@{label="PeaksBid";Expression={$_.column[9]."#text"}}, @{label="PeaksOffer";Expression={$_.Column[11]."#text"}}, @{label="ReportDate";Expression={$todaysDate}}

This produces a nice view of the data in the form of a table but I dont seem to be able to do what I want with it i.e. loop through each row and do stuff.

The resultant table from the code above looks similar to this.

I would like to change this data to a datatable as I am competent at manipulating these. Is this something I can do?

Use Select-Object instead of Format-Table

Mathias R. Jessen
– Mathias R. Jessen

2017-08-02 10:26:05 +00:00
Commented Aug 2, 2017 at 10:26 — Mathias R. Jessen
– Mathias R. Jessen, Commented Aug 2, 2017 at 10:26
spot on thank you, how I do mark this as answered?

Silentbob
– Silentbob

2017-08-02 10:37:06 +00:00
Commented Aug 2, 2017 at 10:37 — Silentbob
– Silentbob, Commented Aug 2, 2017 at 10:37

Mathias R. Jessen · Accepted Answer · 2017-08-02 10:55:55Z

1

Format-Table will return pre-formatted data for displaying in the host application. If you want to select calculated properties for further processing use Select-Object instead:

... | Select-Object -Property @{Label="Period";Expression={$_.column[0]."#text"}},@{label="PeaksBid";Expression={$_.column[9]."#text"}}, @{label="PeaksOffer";Expression={$_.Column[11]."#text"}}, @{label="ReportDate";Expression={$todaysDate}}

answered Aug 2, 2017 at 10:55

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Collectives™ on Stack Overflow

Powershell formatting imported XML as a datatable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related