need to grab part of string from 4th line in field

[andreadd]

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

 

[lbass]

Try this:

stringvar array x := split({table.field},"<");
stringvar y := ubound(x);
if len>1 then
left(y,len-1)

-LB

 

[andreadd]

crystal is not enjoying ubound(x); it says a string is needed in its place. I am completely unfamiliar with ubound so I dont know what to give it instead.

 

[lbass]

Sorry, that should be:

stringvar array x := split({table.field},"<");
stringvar y := x[ubound(x)];
if len>1 then
left(y,len-1)

ubound() returns the ordinal number of the last element in an array.

-LB