andreadd
MIS
- Jan 15, 2008
- 67
SQL 2008 R2 / GoldMine Premium
i am currently tasked with exporting email correspndence from GoldMine. Goldmine does this wacky thing and stores email as an image that SQL sees as binary. so I have a SQL view that I am attaching my report to that casts the email into varchar(max). in crystal with no text interpretation i can see that the 4th line of every single email shows the recipients name and email address
Date: Tue, 23 Feb 2010 09:46:17 -0500
From: andreadd <andreadd@myemail.com>
Subject: Cargo LP Meeting
To: Joe Schmoe <schmoe@theiremail.com>
above is the first 4 lines of every email. so I need a formula to grab just schmoe@theiremail.com
from what I have seen the line breaks are actual chr(10)
does anyone have any idea of how to do this?
TIA for the help - I REALLY appreciate it
i am currently tasked with exporting email correspndence from GoldMine. Goldmine does this wacky thing and stores email as an image that SQL sees as binary. so I have a SQL view that I am attaching my report to that casts the email into varchar(max). in crystal with no text interpretation i can see that the 4th line of every single email shows the recipients name and email address
Date: Tue, 23 Feb 2010 09:46:17 -0500
From: andreadd <andreadd@myemail.com>
Subject: Cargo LP Meeting
To: Joe Schmoe <schmoe@theiremail.com>
above is the first 4 lines of every email. so I need a formula to grab just schmoe@theiremail.com
from what I have seen the line breaks are actual chr(10)
does anyone have any idea of how to do this?
TIA for the help - I REALLY appreciate it