P
Pamela Johnson
Trying to pull data from an Oracle based table.
Field looks as follows when using Microsoft Access:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<HTML>
<HEAD>
<META NAME="GENERATOR" CONTENT="Notepad">
</HEAD>
<STYLE>
P { font: normal 8pt Arial; margin: 0 0 0 0 }
BODY { font: normal 8pt Arial; margin: 0 0 0 0 }
</STYLE>
<BODY>
<P>***DESCRIPTION***</P>
<P>1N32D091 INSPECT AND CLEAN FILTER</P>
<P>***DESCRIPTION END***</P>
<P>***PLANNER NOTE***</P>
<P>UPDATED BY MAI 277912 PERFORMED ON 5-3-2001</P>
<P>***PLANNER NOTE END***</P>
</BODY>
</HTML>
data to keep <body> thru </body>
want to remove the HTML hard coding from this field. Has
anyone run across this problem and is there a solution to
do this using a query? Any suggestions will be greatly
appreciated. If this is performed using a script, will
need specifics.
Field looks as follows when using Microsoft Access:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<HTML>
<HEAD>
<META NAME="GENERATOR" CONTENT="Notepad">
</HEAD>
<STYLE>
P { font: normal 8pt Arial; margin: 0 0 0 0 }
BODY { font: normal 8pt Arial; margin: 0 0 0 0 }
</STYLE>
<BODY>
<P>***DESCRIPTION***</P>
<P>1N32D091 INSPECT AND CLEAN FILTER</P>
<P>***DESCRIPTION END***</P>
<P>***PLANNER NOTE***</P>
<P>UPDATED BY MAI 277912 PERFORMED ON 5-3-2001</P>
<P>***PLANNER NOTE END***</P>
</BODY>
</HTML>
data to keep <body> thru </body>
want to remove the HTML hard coding from this field. Has
anyone run across this problem and is there a solution to
do this using a query? Any suggestions will be greatly
appreciated. If this is performed using a script, will
need specifics.