Skip to main content

Notifications

Power Automate - Power Automate Desktop
Unanswered

Assistance Needed with Extracting Share Quantity from Variable

(1) ShareShare
ReportReport
Posted on by 2

I have successfully extracted the text from the PDF and stored it as 'Shares':

WE HAVE SOLD TO YOU AS DEAL
100,000 shares in SYNCONA ORD NPV at a gross price of GBP 1.189577

Could you please guide me on how to extract '100,000' from this variable? I tried using the Split function, but it didn't seem to work. Your assistance would be greatly appreciated. Thank you very much!

 
Categories:
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 17,110 on at
    Assistance Needed with Extracting Share Quantity from Variable
    Hi
     
    Try to use this approach to capture the shares quantity 
     
    Assuming shares variable has text which you have captured 
     
    Now use Parse text action to parse the text Shares with regex expression to capture shares quantity. 
     
     
    Now the match variable contains the shares quantity, now we need to trim whitespaces from Match variable to get correct shares quantity as shown below
     
     
    After running the process, this captures the Shares Quantity as shown below
     
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!

     
     
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard