topic Re: Convert HTML Column (with CSS) into Text Format in SAS Programming

Convert HTML Column (with CSS) into Text Format

manishiiita — Sun, 25 Jul 2021 09:44:08 GMT

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.

Re: Convert HTML Column (with CSS) into Text Format

ChrisNZ — Sun, 25 Jul 2021 10:06:42 GMT

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?

Re: Convert HTML Column (with CSS) into Text Format

manishiiita — Sun, 25 Jul 2021 10:10:12 GMT

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

Re: Convert HTML Column (with CSS) into Text Format

ChrisNZ — Sun, 25 Jul 2021 10:29:38 GMT

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;

Re: Convert HTML Column (with CSS) into Text Format

ChrisNZ — Sun, 25 Jul 2021 10:35:56 GMT

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

Re: Convert HTML Column (with CSS) into Text Format

Ksharp — Sun, 25 Jul 2021 11:17:30 GMT

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