Webdata to Rows

I am having 0% success!! So I am trying to grab information for a webpage, take that data and then split it into rows/col to use the data elsewhere (spreadsheet/DB). But I am stuck and can't figure out how to do it and/or what I'm doing wrong.

Here is my snippet, which does grab the data correctly and outputs it.

Name {site: text; page=SOMESITE/; selector=.recordHeaderTop :nth-child(3)} {site: text; page=SOMESITE/; selector=.recordHeaderTop :nth-child(5)} # DOB {site: text; page=SOMESITE*; selector=.recordHeader :nth-child(7)} # Record # {site: text; page=https://SOMESITE/; selector=.float-right + .formColumn} # Data {note: preview=no} {webdata={site: text; page=https://SOMESITE/; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table; select=ifneeded; frame=top}} {endnote: trim=right}

{note}

Data:
{=webdata}{endnote}

{note}{datas=split(webdata, ",")}{endnote}
{note}{data2=split.webdata("\n")[1]}{endnote}

{=datas}

Which returns data from the webpage like:

Data:

Record Number: 123456

  • Last Name: doe
  • First Name: john
    Middle Name: bob
    Suffix:
    Title:
  • Gender: MALE
    DOB: 01/01/1999
    Age:

But it is at this point that I am stuck. Once I have the data I can't seem to figure out how to split it into rows.

Any help would be appreciated!

HI @d12welve , there are multiple ways to approach this problem, depending on the format of your source data. Your current snippet seems to pull in only one record at a time, which may not be what you want.

Can you please share a video of your source data and your destination data, so I can better understand the situation? Alternatively, you can email me at gaurang@blaze.today and we can setup a time to meet.

Thanks for offering but I was able to finally figure it out. Below is my somewhat redacted code that works for my situation.

{note}
## Store Basic Information
{recordNum={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(1) > td.wrappedText}}
{lastName={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(2) > td}}
{firstName={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(3) > td}}
{middleName={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(4) > td}}
{dob={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(10) > td}}
## Demographics
{race={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(8) > td}}
{gender={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(9) > td}}
## Identifiers
{ssn={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(13) > td}}
{dlNumber={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(3) > table > tbody > tr:nth-child(14) > td}}
## Contact Information
{address={site: text; page=https://website.com/*; selector=#p_record_primaryAddress}}
{phone={site: text; page=https://website.com/*; selector=#handleMain > div.formSectionWrapper > div.clear-right > div:nth-child(1) > div:nth-child(1) > fieldset > div:nth-child(4) > table > tbody > tr:nth-child(8) > td}}
{endnote}
{formtoggle: name=REPORT#; default=no}{endformtoggle}
{if: `REPORT#`}REPORT #: {formtext: name=REPORT; default=2025}{endif}
{Date={time: MM/DD/YYYY}}
{note}## Output Formatted Data{endnote}
Record Information
Record Number: {=recordNum}
Name: {=lastName}, {=firstName} {=middleName}
DOB: {=dob}
Race: {=race}
Gender: {=gender}
SSN: {=ssn}
OL: {=dlNumber}
Address: {=address}
Phone: {=phone}

1 Like