STUFFC( ) Function

  • Article

Returns a character string created by replacing a specified number of characters in a character expression with another character expression.

STUFFC(cExpression, nStartReplacement, nCharactersReplaced, cReplacement)

Return Values

Character

Parameters

  • cExpression
    Specify the character expression in which the replacement occurs.
  • nStartReplacement
    Specifies the character position in cExpression where the replacement begins.
  • nCharactersReplaced
    Specifies the number of characters to be replaced. If nCharactersReplaced is 0, the entire replacement string cReplacement is inserted into cExpression.
  • cReplacement
    Specifies the replacement character expression. If cReplacement is the empty string, the number of characters specified by nCharactersReplaced are removed from cExpression.

Remarks

STUFFC( ) is designed for expressions containing double-byte characters. If the expression contains only single-byte characters, STUFFC( ) is equivalent to STUFF( ).

STUFFC( ) returns a character string created by replacing a specified number of characters in a character expression with another character expression. The character expressions can consist of any combination of single-byte and double-byte characters.

This function is useful for manipulating double-byte character sets for languages such as Hiragana and Katakana.

See Also

LEFTC( ) | RIGHTC( ) | STUFF( ) | SUBSTRC( )