PDA

View Full Version : Extract value from HTM file



swaggerbox
05-09-2018, 02:50 AM
I'd like to extract value from an HTM file and paste the data directly to Excel sheet. I would like to extract the values from the TITLE, ABSTRACT and CLAIMS.

This is the title

<h1 style='margin-left:-.25pt'>[TITLE]</h1>

<p class=MsoNormal style='margin-top:0in;margin-right:.45pt;margin-bottom:15.2pt;
margin-left:-.25pt'>A control method and system for a centrifugal water cooling
machine set</p>


I'd like to get "A control method and system for a centrifugal water cooling
machine set" and paste to B1

The same is true for ABSTRACT (paste to B2) and CLAIM 0001 (paste to B3), CLAIM 0002 (paste to B4) and so on.

See copy of my source file (https://ufile.io/jzyix)

Could anyone help me get started?

swaggerbox
05-10-2018, 01:00 AM
anyone?