Answered

Extract Number from Data extracted from string using regular expressions

(0) Share

Report

Posted on by Natron26

I'm trying to use regular expression to extract a number from the below string, My automation has me running searches and based on the number in the below string I will perform an action. I want to extract the number 763, the number can also be a single digit or a triple digit, depending on the search. I have extracted the data just not sure how I would use a regular expression and what actions to use to extract the number. Thanks for the help!

str_Varaible 'Showing 1 to 10 of 763 entries'

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

Verified answer

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

If of and entries is constant then you can use below expression
(?<=of).*(?=entries)
Hope this helps
Usha
Natron26 on at

Like
a
(0)

Report
Copy link

Link copied!

Nice Work! Thank you very much!
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What @UshaJyothi20 is the correct regular expression for your use case.

I would just like to note that it should usually be possible to retrieve the element separately from the rest of the string, as it is a dynamic value, so the web page will usually store it as a separate element. Possibly an <a> type.