Regular Expressions in Power Automate Desktop /Set Text Parsing
I'm working with a list extracted from OCR of receipt content in Power Automate Desktop and want to filter for specific numeric groups (prices). The issue is that numbers in 00-00 date format keep getting caught. I’ve tried the following:
1.Regular Expression: [+-]?\b\d{1,3}(?:,\d{3})+\b(.*?)
works for larger numbers but fails to capture smaller ones like -2.
2.Set Text Parsing Start Position: This doesn't work; it always starts from the beginning. For example, I tried setting a dynamically calculated starting position as a variable (in the case of the attached screenshot, 47), but it didn't work as expected.
Additional Information:
The target numeric group always appears at an index calculated as textVariable.length * 4 + 7
The date format is always 00-00, while the price may start with a + or -, may include thousands separators, and can contain decimal places.
I'd prefer to avoid For Each due to high processing time.
Any guidance is appreciated!
Updated answer: (?<!\S)([\d]|[+-])?\b(\d{1,3}(?:,\d{3})*)\b\s
Explanation:
(?<!\S)Ensures no non-whitespace character in the beginning
Regexr link: https://regexr.com/87i2a
Try this: ^([\d]|[+-])?(\b\d{1,3}(?:,\d{3})*\b)\s (requires multiline)
Explanation:
^([\d]|[+-])?Optional start with 0-9, + or -\sHaving this at the end ensures the ending character is a whitespace, matching whole words
Regexr link: https://regexr.com/87i21
- Return elements from a list that match a pattern
- convert/compile regular expressions to C code
- How to make the regex negative lookbehind consume discarded text?
- Generate words that fit in Guids (just for fun)
- Insert newlines before sequences of all-caps words
- Convert all uppercase words in a string to title case
- Add a character in between regex
- RegExp testing fails when string is validated in RegExp tools
- VSCODE snippet PHP to fill namespace automatically
- Regular expression to extract text between square brackets & last string out of the square bracket
- What is the difference between a plus and a star in regex?
- Extract class names from JAR with special formatting
- How to replace a comma with a dot in a number (or any replacement)
- regex to match at certain string and not followed by another string using notepad++
- RegEx for matching UK Postcodes
- Why does the grep command select more than expected?
- Regex for ISO 8601 durations
- Regular expression for number with length of 4, 5 or 6
- Regex to match a whole number not ending in some digits
- Can anyone lead me to DEFINE assertions documentation for regular expressions?
- Regex to find string not followed by separator and 1 or 2 digits
- Regex for quoting unquoted XML attributes
- Regex to extract all the rows from CSV - Apache Nifi
- 12-digit regex for phone number
- regex to exclude lowercase only strings, but save strings which contain capital
- Extract year with an optional plus right after from a string using PHP regex
- missing quotation marks on keys in JSON
- Regex for a valid hashtag
- Enumerate Possible Matches of Regular Expression in Java
- camelCase to underscore in vi(m)