Announcements
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-
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
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 helpsUsha
to this, how can i search with a regular expressionExample need to find all value that have this pattern4000-
5000-
6000-7000-
8000-Example: 3000-000 (NO)700-000 (NO)
7000-00 (YES)7000-000 (YES)7100-000 (YES)
Hi @Celaque
Please try the below regex pattern
.*\d(?=-)
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
usha
Please clarify your scenario.
@UshaJyothi20 wrote:Do yo need to check the value should be greater than 4000then you can check by looping through the data table and use if activity in that if activity write conditioncurrentitem[coloumnname]>4000 in first operandequal to%True% in second operand Hope this helpsushaPlease 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.
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.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 796
Valantis 568
Haque 538
