Examples for all regular expression functions can be found at: pkg_install_location\teradataml\data\notebooks\sqlalchemy\Teradata Vantage Regular Expressions Using SQLAlchemy.ipynb.
Examples in notebooks will help to understand on how values can be passed and these functions cane be used in teradataml.
Supported functions
S/N | Function Name | Description |
---|---|---|
1 | REGEXP_SUBSTR | Extracts a substring from source_string that matches a regular expression specified by regexp_string. |
2 | REGEXP_REPLACE | Replaces portions of source_string that match regexp_string with the replace_string. |
3 | REGEXP_INSTR | Searches source_string for a match to regexp_string. |
4 | REGEXP_SIMILAR | Compares source_string to regexp_string and returns integer value. |
Refer to SQL Documentation for more details on these functions and their signature.
Unsupported functions
- REGEXP_SPLIT_TO_TABLE