Inbound email; Harvest info from subject

[cefladental]

I have inbound email setup to monitor a few email addresses that our phone system sends emails to when a VM is left.

The email contains the usual subject, body, and a .WAV file as an attachment.

In the subject line not only does the phone number show up but so does the caller ID. Does anyone know how I can strip out the phone number and use that data to automatically associate with a known contact or account in Sugar?

Thanks!

-Brett

[Angel]

Try setting up an after or before save logic hook that parses the subject line and extracts phone number. You should be able to do that via a regular expression. Within that same code you can then query the database to find the corresponding contact and link it.