Regex coding to remove additional text

[minimatc 0]

Hello everyone. I am a new bee to Ubot. I am attempting to pull this data from a web page of mine with Regex. i want to put it into a table so i can search it. Below is an example of the code from the page. I put together this code so far

 

<a href="#" onclick="open.*\n.*\n.*\n.*\n.*\n.*

 

that is doing what i want, but I need to remove all of the additional fluff. I am trying to sort it as follows in rows and save it to a searchable table:

 

Single-Family-Home

813190

$200,000

274 Smith Rd

Sometown, CA

John Smith

 

this is the code from the page:

 

<a href="#" onclick="open(35166552); return false;">preview</a>
                    </td><td>Single-Family Home</td><td>813190</td><td>
                        $200,000
                    </td><td>274 Smith Rd</td><td>
                        Sometown, CA
                    </td><td>John Smith</td><td>12</td><td>

 

thank you for your help.

[HelloInsomnia 1103]

You can use add list to list and then use scrape attribute in the bottom part and do tagname td and use innertext, it should get it into a list then you can loop through the list and put it into a table.

[minimatc 0]

Thanks: so i think i set it up correctly, but still the same:

clear list(%test)

add list to list(%test, $find regular expression($document text, "<a href=\"#\" onclick=\"open.*\\n.*\\n.*\\n.*\\n.*\\n.*"), "Don\'t Delete", "Global")

add list to list(%test, $scrape attribute(<td>, "innertext"), "Don\'t Delete", "Global")

 

this is what i got:

 

<a href="#" onclick="open(35166552); return false;">preview</a>

                    </td><td>Single-Family Home</td><td>813190</td><td>

                        $200,000

                    </td><td>274 Smith Rd</td><td>

                        Sometown, CA

                    </td><td>John Smith</td><td>12</td><td>

 

?? thank you you are great at this.

[HelloInsomnia 1103]

Can you show the site you're trying to do this on?

[minimatc 0]

i would need to PM you. it is a paid site that i have to login to.