Skip to main content

Notifications

Power Automate - Power Automate Desktop
Suggested answer

PAD - Extract data from web page - Help with Selector

Posted on 26 Nov 2024 13:00:09 by 10
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.
 

Thanks!
 
Categories:
  • farb_ Profile Picture
    farb_ 10 on 26 Nov 2024 at 16:48:18
    PAD - Extract data from web page - Help with Selector
    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
     
     
  • Suggested answer
    eetuRobo Profile Picture
    eetuRobo 2,300 on 26 Nov 2024 at 15:58:40
    PAD - Extract data from web page - Help with Selector
    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:
  • farb_ Profile Picture
    farb_ 10 on 26 Nov 2024 at 13:31:35
    PAD - Extract data from web page - Help with Selector
    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!
  • Deenuji_Loganathan_ Profile Picture
    Deenuji_Loganathan_ 5,792 on 26 Nov 2024 at 13:17:16
    PAD - Extract data from web page - Help with Selector
    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?
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard