Text Substring Conversion (T)

Text Substring Conversion (Tm,n)

Top  Previous  Next


The text substring extraction code returns a portion of the source data.



The format of the conversion code is





This code behaves identically with ICONV() or OCONV(). The first form returns n characters starting at character m from the source data. The second form returns the last m characters of the source data.


When used as the conversion code in a dictionary item as part of a query, the behaviour of the Tm form is dependent on the justification specified in the dictionary. For left aligned items, the first m characters of the source data are returned. For right justified items, the last m characters are returned.