PAD - Extract data from web page - Help with Selector

(1) Share

Report

Posted on by farb_

Is there a way how to select only the highlighted element?

I'm able to select only the <td> but that's not what I want. I need to select only the first number if possible.

Sample URL: https://bitinfocharts.com/pl/bitcoin/address/bc1ql49ydapnjafl5t2cp9zqpjwe6pdgmxy98859v2-nodusting

Thanks!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you please explain with some example exactly what you want to extract? Like you want to extract only 140 from the first td?

Was this reply helpful? Yes No
farb_ 26 on at

Like (0)

Report
Copy link

Link copied!

Hi - I'd like to extract the entire number: 140,774.82

At the moment I extract the full <td> element and then do some text gymnastics (croping, replacing) to get just that number but it slows the process down a bit so I'm looking for a way to select just this piece of data.

Thanks!

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,522 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You can use advanced settings and use regex inside the action:

That returns all the Saldo values like this:

Paste this action to your PAD:
WebAutomation.ExtractData.ExtractList BrowserInstance: Browser Control: $'''html > body > div:eq(5) > table > tbody:eq(1) > tr''' ExtractionParameters: {[$'''td:eq(3)''', $'''Own Text''', $'''^\\d{1,3}(?:,\\d{3})*(?:\\.\\d{1,2})?'''] } PostProcessData: False TimeoutInSeconds: 60 ExtractedData=> DataFromWebPage

Or you can get just the first rows value:

Was this reply helpful? Yes No
farb_ 26 on at

Like (0)

Report
Copy link

Link copied!

It works, brilliant! :)

Would you be so kind and help me also capture the 4 sets data shown on this screenshot? 🙏🙏🙏

RED - Only the values [capital letteers] (without the small ones on the row 8 for example)

PURPLE - Only the values in brackes without the USD

BLUE - Only the values between the "$" and "@"

GREEN - Only the values after then last "$" symbol

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,522 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Glad to hear it worked. And sure here should be one that takes all those column values.

Action to paste to PAD:
WebAutomation.ExtractData.ExtractTable BrowserInstance: Browser Control: $'''html > body > div:eq(5) > table > tbody:eq(1) > tr''' ExtractionParameters: {[$'''td:eq(2) > span''', $'''Own Text''', $'''^[+-]?\\d{1,3}(?:,\\d{3})*(?:\\.\\d{1,2})?''', $'''Value #1'''], [$'''td:eq(2) > span''', $'''Own Text''', $'''(?<=\$)\\d{1,3}(?:,\\d{3})*(?:\\.\\d{1,2})(?=\\sUSD\$)''', $'''Value #2'''], [$'''td:eq(3)''', $'''Own Text''', $'''^\\d{1,3}(?:,\\d{3})*(?:\\.\\d{1,2})?''', $'''Value #3'''], [$'''td:eq(4)''', $'''Own Text''', $'''[\\d,.]+?(?=\\s*@)''', $'''Value #4'''], [$'''td:eq(4)''', $'''Own Text''', $'''\\d{1,3}(?:,\\d{3})*(?:\\.\\d+)?$''', $'''Value #5'''] } PostProcessData: False TimeoutInSeconds: 60 ExtractedData=> DataFromWebPage

Advanced settings looks like this:

Result:

Was this reply helpful? Yes No
farb_ 26 on at

Like (0)

Report
Copy link

Link copied!

Amazing, thanks a lot!

Was this reply helpful? Yes No