Function: Stuff
Description
Returns a string by replacing number of characters n in string s, starting at position p, using replacement string c.
Syntax
Stuff(s,p,n,c)
Arguments
s is the string you want to insert into, p is the starting position of the substring, n is the number of characters you wish to replace in s, and c is the substring.
Return value
This function returns a string.
Calculated field example
To change a value of Betty’s Music Store in the Customer field to Betty’s New Music Store use the following expression: Stuff(Customer,9,0,"New ")
© 2024 Altair Engineering Inc. All Rights Reserved.