Extracting particular columns from a json converted csv file using powershell, or from the initial json file itself

Question

I had been given a simple Json file which had to be converted to csv. I did so using powershell. The converted csv file has 5 columns out of which I need to extract the 1st and the 5th and then print it in the powershell console and assign it to a variable of a shell code via the batch file.

These are the Csv columns: CSV columns imported from json

Only the headers 'name' and 'last_modified' have to be extracted and assigned to a variable or only printed in the powershell console.

This is the shell command in batch file (cygwin command) in which the column values (via a new csv or directly) have to be assigned to the %2 part.

IF in case this is not possible, just the 'name' and the 'last_modified' keys directly from json have to be assigned to %2 part of the cygwin code.

I have tried importing the csv in powershell and assigning it to $A which shows this output

I have tried using this command as well,

PS D:\> $A | Get-Member name, last_modified -View Extended

but it only shows the first 'name' and the first 'last_modified' value from the csv.

My apologies if this is a very basic question, I am completely new to powershell and batch programming.

Please don't post screenshots of code - cut and paste the text into your question instead and format it with "code fences" - i.e. a line containing three backticks before and after the code. This will make it easier for other people to try to reproduce your issue, and you'll be more likely to get an answer as a result. — mclayton
– mclayton, Commented May 10, 2022 at 8:22
Get-Member name, last_modified --> Select-Object name, last_modified — Theo
– Theo, Commented May 10, 2022 at 9:27

JonasP · Accepted Answer · 2022-05-10 10:48:42Z

1

Get-Member will return only 1 row, you should be using Select-Object as Theo points out in his comment.

Try this to see the difference

$csv = Get-Service

$csv | Get-Member Status, Name #Returns 2 columns but only 1 row

$csv | Select-Object Status, Name #Returns 2 columns and all the rows

answered May 10, 2022 at 10:48

JonasP

212 bronze badges

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

2 Comments

Vader55 Over a year ago

Thanks a lot! 'Select-Object' worked! Now all that's left is to transfer these values to the %2 variable from the cygwin command in the batch file.

JonasP Over a year ago

I'm glad it worked! Dont forget to set the answer as correct so future users with this issue know it has been solved :)

Collectives™ on Stack Overflow

Extracting particular columns from a json converted csv file using powershell, or from the initial json file itself

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related