Description | The |
Syntax | REGEX_EXTRACT( |
Output | text |
Variables
text
: The input text string from which you want to extract text.pattern
: The regular expression pattern used to identify the text to be extracted.offset: (Optional) An offset (number greater than 0) that specifies which match to extract when there are multiple matches in the text.
Example
REGEX_EXTRACT(`Original Text`,"[A-Z]+\d+",1)
ID | Original Text | REGEX_EXTRACT |
1 | Product ID: ABC123, Price: $45.99 | ABC123 |
2 | Order: ORD98765, Date: 2023-09-15 | ORD98765 |
3 | Phone: (555) 555-5555, Email: [email protected] |
|