Powershell : Extract Second line from String

Question

I wish to select the thirdline of text from a sting in powershell.

The string I have is coming from the body of an email:

  $olFolderInbox = 6
  $outlook = new-object -com outlook.application;
  $ns = $outlook.GetNameSpace("MAPI");
  $inbox = $ns.GetDefaultFolder($olFolderInbox)

   foreach ($email in $inbox.items){

         if($email.Subject -eq "PASSED") {

         $Body = $email.Body 

         write-host  $emailSentOn
         write-host  $email.Body 

        } 
 }

The $Body string is formatted like so:

<BLANK LINE>
Queue Cleared!
Server Name
Username

I wish to exact the Server name from the 4 line text string.

Thanks

David · Accepted Answer · 2013-12-23 23:35:21Z

4

Assuming the format is consistent

if ($Body[2] -match '(?m:^Server (?<server>\w+))' ) {
    # do something with $matches.server
}

answered Dec 23, 2013 at 23:35

David

6,5912 gold badges27 silver badges22 bronze badges

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

Comments

mjolinor · Accepted Answer · 2013-12-23 23:35:52Z

1

Using a multi-line regex:

$body = @"

Queue Cleared!
Server Name
Username
"@

#$regex = '(?ms).+?$(.+)?$.+?$.+' #Capture second line.
$regex = '(?ms).+?$.+?$(.+)?$.+' #Capture third line.
$body -replace $regex,'$1'

Server Name

Each .+?$ represents one line of the body. The third line is captured and used for the -replace operation.

The title doesn't quite match the descripion in the post (second line vs third line) so I've included both.

edited Dec 23, 2013 at 23:35

answered Dec 23, 2013 at 23:29

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Comments

Joey · Accepted Answer · 2013-12-23 23:15:43Z

0

You can split a string using the -split operator:

$foo -split "`n"

You'll get an array back. You can then get an element from that array using indexing:

($foo -split "`r?`n")[2]

answered Dec 23, 2013 at 23:15

Joey

357k88 gold badges704 silver badges699 bronze badges

1 Comment

Samuel Meddows Over a year ago

Brilliant! Tank you for the quick response! :)

Knuckle-Dragger · Accepted Answer · 2013-12-24 10:44:16Z

0

This will send only the 3rd item of the array (server name) to the Body. The count starts at zero, so that's why [2] = 3rd.

 $Body[2] = $email.Body

Body result

Server Name

answered Dec 24, 2013 at 10:44

Knuckle-Dragger

7,2524 gold badges28 silver badges41 bronze badges

Collectives™ on Stack Overflow

Powershell : Extract Second line from String

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related