HTML file scraping for Fields in a Table

1 vue (au cours des 30 derniers jours)
v k
v k le 15 Juin 2020
Commenté : v k le 16 Juin 2020
The HTML file that I am working on, is a long one and contains particulars as given in the attached text file. Although the structure is simple and repetitive, due to the large number of characters in between the data fields, I am having hard time in scraping the required data. The objective is to get a two-column excel spreadsheet containing Name in the first column and Email in the second column. How to obtain these required fields in the xlsx file ? Thanks.

Connectez-vous pour répondre à cette question.

Réponses (1)

Sean de Wolski
Sean de Wolski le 15 Juin 2020
Start playing with htmlTree in the Text analytics toolbox.
t = htmlTree(fileread('clientdata.txt'))
t.findElement('TD').extractHTMLText
  1 commentaire
v k
v k le 16 Juin 2020
How to extract the fields "Name " and "Email " after this ?

Connectez-vous pour commenter.

Catégories

En savoir plus sur Text Data Preparation dans Help Center et File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by