Use regex in powershell to get name of server from string with repeatable format

Question

I'd like to use powershell to get the server name from a string in which the format is the same every time. I create a text file using a command in HP's Data Protector. Examples of strings are...

   host="ts-sve-serverT.ca.mycompany.com"  
   host="ts-sve-serverG.ca.mycompany.com"  
   host="ts-sve-serverA.ca.mycompany.com"

There are 3 spaces at the beginning. I'm interested in extracting the server name after the first set of quotes and before the first period. The server name may contain 0 to 2 dashes.

latkin · Accepted Answer · 2013-08-06 19:36:48Z

1

$serverNames = gc 'c:\logfile.txt' |?{ $_ -match '"([^\.]*)\.' } |%{ $matches[1] }

answered Aug 6, 2013 at 19:36

latkin

16.9k3 gold badges51 silver badges64 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:56:36Z

0

Either use the -match operator, as latkin suggested, or the Select-String cmdlet:

$names = gc 'C:\path\to\your.log' | Select-String '"(.*?)\.' | % {
  $_.Matches.Groups[1].Value
}

The above requires PowerShell v3. On earlier versions you'll have to expand the matches like this:

$names = gc 'C:\path\to\your.log' | Select-String '"(.*?)\.' `
  | select -Expand Matches `
  | select -Expand Groups `
  | select -Last 1 Value

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Aug 6, 2013 at 19:47

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Collectives™ on Stack Overflow

Use regex in powershell to get name of server from string with repeatable format

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related