how to get string from powershell's 2 line output

Question

I need to get a string from powershell output. I need to get package name
i.e prompt-toolkit and use it in the pipe below

> pip list --outdated
Package        Version Latest Type
-------------- ------- ------ -----
prompt-toolkit 1.0.15  2.0.3  wheel

pip list --outdated | Where-Object { $exclude -notcontains $_ } | ForEach { pip install -U $_.split(" ")[0] }

UPDATE.
The modified working script

    $(
    $exclude = 'virtualenv', 'prompt-toolkit'
    pip list --outdated --format=freeze  | ForEach{ $_.split("=")[0]} | Where-Object { $exclude -notcontains $_ } | ForEach { pip install -U $_ }                                    
    ) *>&1 >> Python_Modules_Updates_Log.txt

Consider passing the pip list in json format pip list --outdated --format=json | ConvertFrom-Json — user6811411
– user6811411, Commented Jun 27, 2018 at 13:48
@LotPings, thank you. I have looked into the --format options, and have chosen freeze option. That way i need not use the select-object -skip 2 — LetzerWille
– LetzerWille, Commented Jun 27, 2018 at 14:06

Larry Song · Accepted Answer · 2018-06-27 04:56:37Z

1

simply try

pip list --outdated | select-object -skip 2 | Where-Object { $exclude -notcontains $_ } | ForEach { pip install -U $_.split(" ")[0] }

answered Jun 27, 2018 at 4:56

Larry Song

1,16410 silver badges17 bronze badges

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

1 Comment

user6811411 Over a year ago

The Where can't work properly as $_ still contains all columns. I'd do the split in a calculated property

pip list --outdated | select-object -skip 2 -property @{n='Package';e={$_.split(' ')[0]}} | Where-Object Package -notin $exclude

Paxz · Accepted Answer · 2018-06-27 06:47:26Z

0

To get the Packagenames of the list, you can use the -ExpandProperty feature of Select-Object and pipe it to the install command:

pip list --outdated | Select-Object -ExpandProperty Package | Where-Object { $exclude -notcontains $_ } | ForEach { pip install -U $_}

answered Jun 27, 2018 at 6:47

Paxz

3,0661 gold badge22 silver badges36 bronze badges

Collectives™ on Stack Overflow

how to get string from powershell's 2 line output

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related