Split pattern output by spaces in Powershell

Question

I need to extract the third column of a string returned after matching a Pattern. It also needs to be a one-liner

File contains data like this:

f5834eab44ff bfd0bc8498d8 1557718920
dc8087c38a0d a72e89879030 1557691221
e6d7aaf6d76b caf6cd0ef68c 1557543565

Right now it matches the pattern and returns the line. But I cannot get it to Split on the spaces so I can get the 3rd column (index 2).

    select-string -Path $hashlistfile -Pattern 'dc8087c38a0d') | $_.Split(" ") | $_[2]

Output should be:

1557691221

Mathias R. Jessen · Accepted Answer · 2019-05-22 13:33:04Z

2

You can grab the Line property from the output object produced by Select-String, split that and then index directly into the result of String.Split():

Select-String -Path $hashlistfile -Pattern dc8087c38a0d |ForEach-Object {
  $_.Line.Split(" ")[2]
}

answered May 22, 2019 at 13:33

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

1 Comment

Ansgar Wiechers Over a year ago

@elcool You were also missing the ForEach-Object. ... | $_.Split() is invalid syntax.

js2010 · Accepted Answer · 2019-05-22 15:24:09Z

0

You can only use '$_' inside cmdlets that have a script block option '{ }'. Select-string returns MatchInfo objects.

(select-string dc8087c38a0d $hashlistfile).gettype()

IsPublic IsSerial Name                                     BaseType
-------- -------- ----                                     --------
True     False    MatchInfo                                System.Object

The -split operator seems to deal with it more easily. There's an extra parenthesis ')' after the pattern in your example.

select-string dc8087c38a0d $hashlistfile | foreach { -split $_ | select -index 2 }

1557691221

edited May 22, 2019 at 15:24

answered May 22, 2019 at 14:11

js2010

28.4k6 gold badges82 silver badges88 bronze badges

Collectives™ on Stack Overflow

Split pattern output by spaces in Powershell

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