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

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-23
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
lifecycle
latest
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