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
- Perl Regex fails to compile looking for \object
- Test if elements in a character string could be numeric
- How to remove all but emojis in a (Javascript) string?
- How to remove all characters from string apart from emoji
- How can I find all matches to a regular expression in Python?
- Zip code validation to exclude some formats
- How to allow specific words using javax.validation.constraints.Pattern?
- Create array of regex matches
- Handling complex parentheses structures to get the expected data
- Catching optional content just after a new line
- Regex to compare strings with Umlaut and non-Umlaut variations
- How can I check when there are only opening or closing quotes in PHP to make replacements?
- Regular Expression | Leap Years and More
- Regex date format validation on Java
- How can I replace every instance of a character from 3 groups of characters with just 3 different characters respectively?
- Regex to match 1 or less occurrence of string?
- Getting parts of a URL (Regex)
- Trim trailing spaces before newlines in a single multi-line string in JavaScript
- Only keep this String in Notepad++ (Regex)
- Redirect Youtube channel main page to videos section the proper way using regex
- Regular expression to validate repeating comma-separated groups without trailing comma
- Angular regex validator allows empty value, while the regex clause should demand at least one digit
- Parsing DeepDiff result
- Rewriting HTTP url to HTTPS using regular expression and javascript
- regex to match HTML <p ...> tag starting with a lowercase letter
- String.split() *not* on regular expression?
- How can I find the last occurance of a dot not preceding with a slash?
- How to extract table names and column names from sql query?
- How to use Rust regex on bytes (Vec<u8> or &[u8])?
- How to validate email by whitelist domain regex