STUFFC( ) Function

See Also

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

Syntax

STUFFC(cExpression, nStartReplacement, nCharactersReplaced, cReplacement)

Returns

Character

Arguments

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.