Extract Strings
Extracts strings that match the conditions of a regular expression.
URL
https://api.excelapi.org/language/regex-match
Configuration
| Configuration | Required | Description |
|---|---|---|
| text | ✔ | Specifies the target string of the regular expression |
| regex | ✔ | Specifies a regular expression |
| line | If there are multiple strings matching the condition, specify the number of the first match. If not specified, the first match is returned. |
Example
C2:
=WEBSERVICE("https://api.excelapi.org/language/regex-match?text="&ENCODEURL($A2)&"®ex="&ENCODEURL($B2))