I am trying to clean up text that contains some html code. How do I remove multiple occurrences of “< any characters >”?

I am currently using a calc field containing:

Let ( text= Trim(Substitute ( Descriptiton__lxt ;

[" *" ;"¶" ];

["*" ;".¶" ];

[""" ;"'" ] ;

["’" ;"'" ];

["

oops...

I am trying to clean up text that contains some html code. How do I remove multiple occurrences of “< any characters >”?

I am currently using a calc field containing:

Let ( text= Trim(Substitute ( Descriptiton__lxt ;

[" *" ;"¶" ];

["*" ;".¶" ];

[""" ;"'" ] ;

["’" ;"'" ];

["�" ;"®" ];

["™" ;"™" ];

["%" ;"%" ];

["?" ;"/" ]

)

)

& "." ;

Case(

// remove leading paragraph character.

Left(text; 1)="<";Right(text; Length(text)-5);

Left(text; 1)=".";Right(text; Length(text)-5);

text

))

Sample data:

The hat is made from durable, 100% polyester and the mask is made of 90% polyester and 10% spandex that stretches for a comfortable fit. The Carhartt logo label appears on the front.

Read more about our high-visibility line. *Polyester/spandex blend *Pull-down face mask *One size fits all

You'll need a recursive function to do this. Look on BRian Dunning's web site.