Answered

Searching with regular expresion on excel

(0) Share

Report

Posted on by Celaque

Hello there!
I need to do a search in excel for characters that match a regular expression but excel functions don't seem to work with regular expressions.

The regular expresion is: \b(4|5|6|7|8)\d\d\d\b-

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

Regex expression is wrong please share sample input so that I can share the correct reject pattern
If you want to use excel and want to search
Then you can use excel as database and then you can use SQL query by searching the required value

Hope this helps
Usha

Was this reply helpful? Yes No
Celaque 44 on at

Like (0)

Report
Copy link

Link copied!

I'm testing the Regex Expression this and its correct:
@UshaJyothi20 wrote:
Regex expression is wrong please share sample input so that I can share the correct reject pattern
If you want to use excel and want to search
Then you can use excel as database and then you can use SQL query by searching the required value

Hope this helps
Usha
to this, how can i search with a regular expression
Example need to find all value that have this pattern
4000-
5000-
6000-
7000-
8000-
Example:
3000-000 (NO)
700-000 (NO)
7000-00 (YES)
7000-000 (YES)
7100-000 (YES)

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Celaque

Please try the below regex pattern
.*\d(?=-)

Hope this helps
Usha

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

Do yo need to check the value should be greater than 4000
then you can check by looping through the data table and use if activity in that if activity write condition
currentitem[coloumnname]>4000 in first operand
equal to
%True% in second operand

Hope this helps
usha
Please clarify your scenario.

Was this reply helpful? Yes No
Celaque 44 on at

Like (0)

Report
Copy link

Link copied!

@UshaJyothi20 wrote:
Do yo need to check the value should be greater than 4000
then you can check by looping through the data table and use if activity in that if activity write condition
currentitem[coloumnname]>4000 in first operand
equal to
%True% in second operand

Hope this helps
usha
Please clarify your scenario.

Let's forget the fact if the expression is correct or not, what I directly need to know is if you can search values in excel with regular expressions. In the action "Find and replace cells in Excel worksheet" sample in the attachment:

Apologize for any confusion in the question.

Was this reply helpful? Yes No
Verified answer

Celaque 44 on at

Like (0)

Report
Copy link

Link copied!

Thanks for all help, already make the solution for the topic, I use the action "Find and replace data tables" where is avaible to search with regular expression.

Was this reply helpful? Yes No