Using Powershell to parse through a variable

Question

I have script that goes through my emails then returns the body of each of the emails that matches my query. The body looks something like this

Recipients:     [email protected] 
Attachment  Report.pdf 
Timestamp of Message:   18 January 2016 

Recipients:     [email protected] 
Attachment  Report2.pdf 
Timestamp of Message:   18 January 2016

I'm trying to either get each line of the body in a custom-object or just extract the email addresses to a variable to do more work with. Any ideas.

Is it returning an array of single line strings, an array of multi-line strings (one per email body), or a single multi-line string with all of the bodies? — mjolinor
– mjolinor, Commented Jan 18, 2016 at 3:46
If you send it to a variable, what is the .count property of that vaiable? — mjolinor
– mjolinor, Commented Jan 18, 2016 at 3:55

mjolinor · Accepted Answer · 2016-01-18 16:16:21Z

3

One option is to use a multi-line regex to capture the data, and then create a custom object from the captures:

Edit: Updated with example using ForEach loop.

$regex = @'
(?ms)Recipients:\s+(.+?)\s* 
Attachment\s+(.+?)\s* 
Timestamp of Message:\s+(.+)
'@ 

$Result=
ForEach ($text in $variable)
 {
   if ($text -match  $regex)
     {
       [PSCustomObject]@{
        Recipients = $matches[1]
        Attachment = $matches[2]
        Timestamp  = $matches[3]
        }
     }
 }

Recipients                        Attachment  Timestamp      
----------                        ----------  ---------      
[email protected] Report2.pdf 18 January 2016

edited Jan 18, 2016 at 16:16

answered Jan 18, 2016 at 4:06

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

5 Comments

Empyre Over a year ago

In your example how do I add the variable from the output of my original query to the $text array

mjolinor Over a year ago

Since your variable is an array, you can run it through a ForEach loop.I'll update the answer with an example.

mjolinor Over a year ago

Had a copy/paste fail and left out the regex when I did the update. Fixed.

Empyre Over a year ago

Man - I can't give you a +1 yet since I don't have enough of a rep yet. But that is awesome. Thanks

Empyre Over a year ago

See my Answer below, but it's also a question sinc eI'm trying to add each output object to a variable with the properties

Collectives™ on Stack Overflow

Using Powershell to parse through a variable

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related