Download, Parse, & Account for Empty Fields

I am running into some challenges trying to scrape HTML data.

Basically, I want to extract all the field+ response pairs depicted in the attached page/table image below. (Each hull has its own page/table.)

I am in the process of building an iterative macro to process each URL (page), download the page HTML, and extract the table fields and responses.

There will not be a response to each field. Some fields will be blank.

The attached workflow depicts two ways I was trying to get to the data. The problem is I need to account for the blank responses. (The workflow includes 10 different page downloads.)

(Note: This is all open-source data.)

toCommunity_parse_html_pain.yxzp

Regex

Parse

Help

Accepted answers

dougperez

I was looking into my example and I found a problem: the headers hahahah

Now I think its more accurated

Try to filter that headers into another way (i used a filter and wrote down those, assuming that is standardized)

Example_Test.yxmd

All comments

dougperez

This helps you? I used multirow formula (with one Hull to test, just group by Hulls)

Example_Test.yxmd

dougperez

I was looking into my example and I found a problem: the headers hahahah

Now I think its more accurated

Try to filter that headers into another way (i used a filter and wrote down those, assuming that is standardized)

Example_Test.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703