StringRegExp Question

[LurchMan]

Hey Everyone -

I'm working on a small script that is going to read emails out of outlook with the subject line "spam". I've already figured out how to do this but the issue I'm having is I can't figure out how to extract email address out of the body of the email. Almost all of the emails have "mailto:something@spam.com" in the body because they are forwarded to me, but some of them don't. I was wondering if there was a way to do this using StringRegExp to get just the email address.

Hope I explained this well enough, let me know if I didn't

Thanks for any help in advance

Lurch

[GEOSoft]

$sSre = ".*(\b.+@.+\b).*", "$1"
$sAddress = "mailto:something@spam.com"
$sAddress = StringRegExpReplace($sAddress, $sSre, "$1")
MsgBox(0, "Result 1", $sAddress)

$sAddress = "noreply@spamit.com"
$sAddress = StringRegExpReplace($sAddress, $sSre, "$1")
MsgBox(0, "Result 2", $sAddress)

[GEOSoft]

I should have added that you will need some method to get the message header before you use the code I posted. If you still have trouble then I'll have a look at a standard .eml file and work it out from there. It runs in my mind that the line you are looking for is something like ReplyTo:somename@someaddress.com

It that is correct then $sSre would be

"(?i)(?m:^)ReplyTo.*(\b.+@.+\b).*", "$1"

Edited October 6, 2009 by GEOSoft

[LurchMan]

$sSre = ".*(\b.+@.+\b).*", "$1"
$sAddress = "mailto:something@spam.com"
$sAddress = StringRegExpReplace($sAddress, $sSre, "$1")
MsgBox(0, "Result 1", $sAddress)

$sAddress = "noreply@spamit.com"
$sAddress = StringRegExpReplace($sAddress, $sSre, "$1")
MsgBox(0, "Result 2", $sAddress)

Thank you for your quick response.

and maybe my brain just isn't working yet but why would I use StringRegExpReplace rather than StringRegExp?

Edit: I tried using both and i get the result i expected with StringRegExp. Thank you for your help!

Edited October 6, 2009 by LurchMan

[GEOSoft]

Thank you for your quick response.

and maybe my brain just isn't working yet but why would I use StringRegExpReplace rather than StringRegExp?

Edit: I tried using both and i get the result i expected with StringRegExp. Thank you for your help!

Either would work. I just used the Replace to strip out everything except the email address. Using the RegEx with the 1 0r 3 flags will return an array of all email addresses found and that could actualy be beneficial in that it would allow you to select the address you wanted. Using it with the 0 flag (same as no flag) will tell you if there is an email address in the message.

Question: Are you using this with standard *.eml files?

Edited October 6, 2009 by GEOSoft