Convert HTML Column (with CSS) into Text Format

[manishiiita]

I have SAS Data set with one of the column defined in HTML format. I have to convert this HTML Column into Text format. I have used Perl based HTML parsers, but it is not working.

We have French Alphabet characters in above comments (first line; â, ê, î, ô, û); and it should be available as actual French text characters (â, ê, î, ô, û) post conversion.

Is there any way to do it in SAS?

If not in SAS programming, is there any way to show it as a report as we are displaying above data into a Stored Process report?

Thanks in advance for your help.

[ChrisNZ]

So you want to remove html tags and just keep the text?

Or do you want to reuse the html as is in a SAS generated report?

[manishiiita]

I want to keep only the text from it. I'm going to show actual text in report. So, no need to reuse html.

[ChrisNZ]

How about removing tags with this simple (but not fail proof) syntax?

data T;
  HTML='<a>sfdsfdsf</a>sdsd';
  TEXT=prxchange('s/<[^>]*?>//',-1,HTML);
run;

[ChrisNZ · Accepted solution]

For the accents, you have to do that manually, for example using function TRANSTRN as function URLDECODE is rather limited. Unfinished even.

[Ksharp]

Post some sample data and the output you want see, that would be better to explain your question.