Formula (Extended): $REPLACE Function

2023-12-062024-06-07

Overview¶

Convert a specified number of characters from the target string into another character.

$REPLACE(Target String, Start Position, Number of characters, Replacement String)

Parameter	Type	Required	Description
Target String	Arbitrary String	Required
Start Position	Half-width numerical value. Integer of 1 or more	Required	Specify the position of the first character to be replaced with the replacement string. The first character is 1.
Number of characters	Half-width numerical value. Integer of 1 or more	Required	Specify the number of characters to be replaced with the replacement string.
Replacement String	Arbitrary String	Required

Parameter	Classification	Numerical Value	Date	Description	Check
Target String	Yes	Yes	Yes	Yes	No
Start Position	Yes	Yes	No	Yes	No
Number of characters	Yes	Yes	No	Yes	No
Replacement String	Yes	Yes	Yes	Yes	No

The string after replacement.

Target	Return Value
Classification (including title, status, manager, owner)	Display return value. If the return value is a half-width numerical value and is a drop-down list with values, display the options that match the return value.
Numerical Value (including work volume, progression rate, remaining work volume)	Displays the return value only if the return value is a half-width numerical value.
Date (including start and completion)	Display return value only if the return value is a string in date format.
Description (including content)	Display return value.
Check (including lock)	Do not display.