Solved: Convert HTML field to unicode

sgtrun · Posted 06-29-2017 03:17 PM

<html>

<body>

In Excel I can use the Paste Special to read this this and convert it to Unicode and get rid of the HTML.

Any way to do this in SAS?

<div align="left" style="min-height: 9pt; ">Stover,Susan<TEST>, 6/21/2018 12:47:47 PM:  </div>

<div align="left" style="min-height: 9pt; ">Can this be set to retest with recent or new records?  This issue

was encountered while Susan was testing code</div>

<div align="left" style="min-height: 9pt; "> ________________________________________

</div>

</body>

</html>

Ksharp · Posted 06-30-2017 07:49 AM

How about this one:

data have;
infile cards truncover;
input x $2000.;
new_x=urldecode(prxchange('s/<[^<>]+>//',-1,x));
cards4;
<html>
<body>
In Excel I can use the Paste Special to read this this and convert it to Unicode and get rid of the HTML.
Any way to do this in SAS?
<div align="left" style="min-height: 9pt; "><font face="Arial" color="#000080"><span style="font-size:8pt"><b>Stover,Susan&lt;TEST&gt;, 6/21/2018 12:47:47 PM:&nbsp;</b></span></font><font face="Arial"><span style="font-size:8pt"> <br /></span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt">Can this be set to retest with recent or new records?&nbsp; This issue
was encountered while Susan was testing code</span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt"><br /></span></font><font face="Arial" color="#000080"><span style="font-size:8pt"><b>________________________________________</b></span></font><font face="Arial"><span style="font-size:8pt"><br /></span></font><p></p>
</div>
</body>
</html>
;;;;
run;

proc print noobs;run;

View solution in original post

Ksharp · Posted 06-30-2017 07:49 AM

How about this one:

data have;
infile cards truncover;
input x $2000.;
new_x=urldecode(prxchange('s/<[^<>]+>//',-1,x));
cards4;
<html>
<body>
In Excel I can use the Paste Special to read this this and convert it to Unicode and get rid of the HTML.
Any way to do this in SAS?
<div align="left" style="min-height: 9pt; "><font face="Arial" color="#000080"><span style="font-size:8pt"><b>Stover,Susan&lt;TEST&gt;, 6/21/2018 12:47:47 PM:&nbsp;</b></span></font><font face="Arial"><span style="font-size:8pt"> <br /></span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt">Can this be set to retest with recent or new records?&nbsp; This issue
was encountered while Susan was testing code</span></font></div>
<div align="left" style="min-height: 9pt; "><font face="Arial"><span style="font-size:8pt"><br /></span></font><font face="Arial" color="#000080"><span style="font-size:8pt"><b>________________________________________</b></span></font><font face="Arial"><span style="font-size:8pt"><br /></span></font><p></p>
</div>
</body>
</html>
;;;;
run;

proc print noobs;run;

Convert HTML field to unicode

Re: Convert HTML field to unicode

Re: Convert HTML field to unicode

Convert HTML field to unicode

Re: Convert HTML field to unicode

Re: Convert HTML field to unicode

Registration is open

SAS Training: Just a Click Away