Optional Syntax Elements for TD_StrApply - Analytics Database

Database Analytic Functions
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™
OutputColumns
[Ignored with Inplace ('true'), otherwise optional.] Specifies the name for the output columns. An output_column cannot exceed 128 characters.
Default: With InPlace ('false'), target_column_operator; otherwise target_column
If any target_column_operator exceeds 128 characters, specify an output_column for each target_column.
Accumulate
Specifies the names of the input table columns to copy to the output table.
With InPlace ('true'), no target_column can be an accumulate_column.
String
[Required when str_operator needs string argument, ignored otherwise.] Specifies the string argument for str_operator:
str_operator string
STRINGCON String to concatenate to value.
STRINGINDEX String for which to return index of its first character in value.
STRINGLIKE Pattern that describes string to find in value.
STRINGPAD String with which to pad value.
STRINGTRIM String to trim from value.
StringLength
[Required when str_operator needs length argument, ignored otherwise.] Specifies the length argument for str_operator:
str_operator length
GETNCHARS Number of characters to return from value.
STRINGPAD Length to which to pad value.
SUBSTRING Substring length.
OperatingSide
Applies only when str_operator is GETNCHARS, STRINGPAD, or STRINGTRIM. Specifies side of value on which to apply str_operator.
Default: left.
IsCaseSpecific
Applies only when str_operator is STRINGINDEX or STRINGLIKE. Specify whether search for string is case-specific.
Default: true (search is case-specific).
EscapeString
Applies only when str_operator is STRINGLIKE. Specify the escape characters.
IgnoreTrailingBlank
Applies only when str_operator is STRINGLIKE. Specify whether to ignore trailing space characters.
StartIndex
Applies only when str_operator is SUBSTRING. Specify the index of the character at which the substring starts.
InPlace
Specifies whether the output columns have the same names as the target columns.
InPlace ('true') effectively replaces each value in each target column with the result of applying str_operator to it.
InPlace ('false') copies the target columns to the output table and adds output columns whose values are the result of applying str_operator to each value.
With InPlace ('true'), no target_column can be an accumulate_column.
Default: true.