Strip HTML codes ??

tford

Is anyone familiar with a way to use REPLACE_PATTERN to strip HMTL codes when copying from one attribute to another? Basically I would want to strip anything that had all occurrences with < > and of course whatever is between the brackets.

If it's possible, I'm guessing it's by using a Regular Expression (which I don't really have a handle on).

Thanks!

RLJB

Hi Tom

Yes I have done it using regex, pretty successful, there is a post on this forum with my example, I think I have refined a little since then, but a good start.

kklosson

Not expert assistance, just trying to help...

Use three functions: REPLACE_PATTERN, SUBSTRING, and INDEX_OF.

REPLACE_PATTERN(SUBSTRING(INDEX_OF(BO.Attribute,'<'),INDEX_OF(BO.Attribute,'>')),' ')

No idea if this will work, and not sure if I constructed it right, but it's the first thing I would try. This function breaks if there is a legitimate < or > in the string. So you should first do two REPLACE_PATTERN functions:

REPLACE_PATTERN(BO.Attribute,'<','?')
REPLACE_PATTERN(BO.Attribute,'>','?')

Use whatever you want for ?, even a space. Let us know if I was even close.