We have a "Note" field in one of our databases. Problem is when I use that field in Cystal, it pulls all the font information, etc. as well (see below):
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><STYLE type=text/css> P, UL, OL, DL, DIR, MENU, PRE { margin: 0 auto;}</STYLE><META content="MSHTML 6.00.3790.3091" name=GENERATOR></HEAD><BODY leftMargin=1 topMargin=1 rightMargin=1><FONT face=Tahoma size=2><DIV>High Plains Technology</DIV></FONT></BODY></HTML>
What I need to is just pull out the data between the two <DIV> . In this case, I just need to see "High Plains Technology". Is there a formula I can use to do this?
IP Logged
