NVP Function Syntax | VantageCloud Lake - NVP Function Syntax - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
[TD_SYSFNLIB.] NVP (
  instring,
  name_to_search
  [, name_delimiters ]
  [, value_delimiters ]
  [, occurrence ]
)

Syntax Elements

TD_SYSFNLIB
Name of the database where the function is located.
instring
The name-value pairs separated by multibyte delimiters.
name_to_search
The name whose instring value NVP returns.
name_delimiters
The multibyte delimiters used to separate name-value pairs.
Delimiters can contain any characters, and are separated in the string by spaces. A space used as part of a delimiter must be escaped using a backslash (\). The maximum length of any delimiter is 10, and the maximum size of this parameter is 32.
This parameter is optional and if not specified, the default value is & (ampersand).
value_delimiters
The multibyte delimiters used to associate a name to its value in a name-value pair.
Delimiters can contain any characters, and are separated in the string by spaces. A space used as part of a delimiter must be escaped using a backslash (\). The maximum length of any delimiter is 10, and the maximum size of this parameter is 32.
This parameter is optional and if not specified, the default value is = (equal sign).
occurrence
The number of occurrences of name_to_search that NVP searches for.
This parameter is optional and if not specified, the default value is 1.