Tag Archives: Nth character of a CHAR

Extracts the Nth character of a CHAR or CLOB variable

This function extracts the Nth character of a CHAR or CLOB variable. This function runs much faster than the usual functions such as mid$or seg$ when managing large CLOB data. Syntax: EXTRACTED_CHARACTER=Xgetchar(CLOB_SOURCE,POSITION) Parameters: CLOB_SOURCE has been declared by using a Clbfile or a Char  POSITION has been declared by using an Integer EXTRACTED_CHARACTER has been… Read More »