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

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Published
November 2021
Language
English (United States)
Last Update
2022-01-14
dita:mapPath
bol1585763678431.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
B700-4006
lifecycle
previous
Product Category
Teradata Vantage
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