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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

UshaJyothiKasibhotla 203 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Natron26 on at

Like (0)

Report

Nice Work! Thank you very much!

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No