Not sure if this will work for you but if the text you are looking for is always surrounded by the "<p>" tags and there is only one set then the following will extract what is between:
SUBSTR($VALUE$,STRSTR($VALUE$,"p>")+2,STRSTR($VALUE$,"</p")-1) Other than that you could run a process where you pass the HTML to an HTML to Text converter of which there are many. Google "Convert HTML to Text". On Thu, Sep 17, 2009 at 7:04 AM, Brandi Barbour <barbour.bra...@epamail.epa.gov> wrote: > ** All, > I hope someone has an easy solution to this problem. > For example if i have a field that has a value of <font face="Helv" > size="2"><font face="Helv" size="2"><blockquote><p>CM - > Testing</p></blockquote></font></font> and I need it to just have CM - > Testing > I am trying to use a set fields with REPLACE($csc_char_label1$, "<%>", "") > However this is not working and returning the whole value. Anyway to use > the wildcard with this function? The reason is that the value changes with > different html tags and i would like a universal replace to work but maybe > it will not. > Any help is appreciated. > > Thanks, > Brandi > Windows 2003 > SQL 2005 > ARS 7.0.1 patch 003 > ITSM 7.1 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the > Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"