Home Page for the TeradataForum
 

 

UDF Library: 'nthValue'

Component: 'readme.txt'


 
  nthValue.c >>

Function: nthValue

Author:   Robert D. Meunier - Database Fusion

Version:  1.0

Purpose:  To extract the Nth value from a delimited list of values.

Syntax:   nthValue( InputString, Delimiter[*], NthPosition)

Where:    InputString:  A SQL VarChar datatype containing the list of
                        delimited values.

          Delimiter:    The character that is used to delimit the list.
                        The delimiter must be a single character followed
                        by an optional asterisk. The asterisk says to
                        treat multiple back to back delimiters as a single
                        delimiter.

          NthPosition:  The value from within the delimited list that
                        is to be returned.

Returns:  A SQL VarChar datatype containing the requested postitional
          value from the list of values. If a NULL InputString is
          supplied NULL will be returned. If NthPosition is out of range
          a zero length string will be returned.


  nthValue_v.c >>





 
  Top Home Privacy Feedback  
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky
Copyright 2016 - All Rights Reserved
Last Modified: 28 Jun 2020