REGEXPFIND Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=REGEXPFIND Function |titlemode=append |keywords=planfix, function, REGEXPFIND |description=REGEXPFIND Function }} The REGEXPFIND function allows you to extract the required text fragment from a variable or an infoblock. == Format == *'''REGEXPFIND('''text; pattern''')''' Arguments: *'''text''' — required, text where we search with a regular expression. *'''pattern''' — required, regular expression. == Examples == {| class="wikitable" |- ! style=...") |
(→Go To) |
||
| Line 42: | Line 42: | ||
== Go To == | == Go To == | ||
*[[Standard functions]] | *[[Standard functions | Standard operators and Planfix functions]] | ||
*[[ | *[[Calculated fields]] | ||
*[[Reports]] | |||
Revision as of 14:46, 7 February 2024
The REGEXPFIND function allows you to extract the required text fragment from a variable or an infoblock.
Format
- REGEXPFIND(text; pattern)
Arguments:
- text — required, text where we search with a regular expression.
- pattern — required, regular expression.
Examples
| Formula | Description | Result |
|---|---|---|
| REGEXPFIND("Buy 30000$"; "(\d+)") | Extract a number from text using a regular expression | 30000 |
Important
- Regular expressions in Planfix are executed with the options Pattern.DOTALL and Pattern.MULTILINE. In the online validator — gms.
- The first capturing group falls into the result of text processing using a regular expression. Accordingly, what needs to be in the result, you need to take in parentheses, and make the rest of the groups non-capturing (?:).
- To get data from a string with quotes inside using a regular expression, you need to
escape them.