If you think about it, the string "<%>" will match your entire string
<font face="Helv" size="2"><font face="Helv" size="2"><blockquote><p>CM -
Testing</p></blockquote></font></font>
< %
>
Without resorting to an external routine to remove the HTML tags you would have
to use a loop that does something like the following
Find first "<" (use the STRSTR function
Find first ">" (use the STRSTR function
Remove the text found above
If there still exists a "<" in string go to the top
Ooh... You could do it in a single filter
Run-If: $field$ LIKE "%<%"
Action 1 Set Fields $zTempInt1$ = STRSTR( $field$, "<" )
Action 2 Set Fields $zTempInt2$ = STRSTR( $field$, ">",
$zTempInt1$ + 1 )
Action 3 Set Fields $field$ = REPLACE( $field$, SUBSTR(
$field$, $zTempInt1$, $zTempInt2$ ), "")
Action 4 Goto Execution Order of this filter
NOTE: This is typed off the top of my head before I have had my coffee, but it
should work.
Fred
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Brandi Barbour
Sent: Wednesday, September 16, 2009 11:05 PM
To: [email protected]
Subject: Question concerning REPLACE function
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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
