Regular Expression Functions | SQLAlchemy | teradataml - 17.00 - Regular Expression Functions - Teradata Package for Python

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Release Date
November 2021
Content Type
User Guide
Publication ID
B700-4006-070K
Language
English (United States)
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