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)

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.

Return Value

Character

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

Reference

LEFTC( ) Function

RIGHTC( ) Function

STUFF( ) Function

SUBSTRC( ) Function

Other Resources

Functions

Language Reference (Visual FoxPro)