REGEXP_SPLIT_TO_TABLE Function Syntax | Teradata Vantage - REGEXP_SPLIT_TO_TABLE Function Syntax - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
Product Category
Teradata Vantageā„¢
[TD_SYSFNLIB.] REGEXP_SPLIT_TO_TABLE ( inkey, source_string, regexp_string, match_arg )

Syntax Elements

TD_SYSFNLIB.
Name of the database where the function is located.
inkey
A numeric or character argument that uniquely identifies the source_string in the output result set.
If the inkey is NULL, an empty string is returned.
source_string
A character argument.
If source_string is NULL, 0 rows are returned. Zero rows are also returned if the source_string is the empty string.
regexp_string
A character argument.
If regexp_string is NULL, the original source_string is returned.
match_arg

A character argument.

Valid values are:
  • 'i' = case-insensitive matching.
  • 'c' = case sensitive matching.
  • 'n' = the period character (match any character) can match the newline character.
  • 'm' = source_string is treated as multiple lines instead of as a single line. With this option, the '^' and '$' characters apply to each line in source_string instead of the entire source_string.
  • 'l' = if source_string exceeds the current maximum allowed source_string size (currently 16 MB), a NULL is returned instead of an error. This is useful for long-running queries where you do not want long strings causing an error that would make the query fail. Although the maximum source_string size is 16 MB, the resulting token can only be VARCHAR, and has a maximum return token size of 64000 bytes.
If match_arg is not specified, an error is returned.
If there is no match, the original source_string is returned.
outkey
The value of inkey.
token_ndx
The ordinal position of the token in the input string.
token
A character argument.
The token from the input string in the same character set as instring.
REGEXP_SPLIT_TO_TABLE does not support the output type of CLOB in the token section.