Formula (Extended): $SUBSTITUTE Function

Dec 6, 2023Jun 7, 2024

Overview¶

Convert a specific string in the target string to a specified string.

$SUBSTITUTE(Target String,Search String,Replacement String,[Replacement Target])

Parameter	Type	Required	Description
Target String	Arbitrary String	Required
Search String	Arbitrary String	Required
Replacement String	Arbitrary String	Required
[Replacement Target]	Half-width numerical value. Integer of 1 or more	Optional	Specifies which search string to replace among the search string contained in the target string. If "2" is specified, only the second occurrence of the search string will be replaced. If omitted, all search strings appearing in the target string will be replaced.

Parameter	Classification	Numerical Value	Date	Description	Check
Target String	Yes	Yes	Yes	Yes	No
Search String	Yes	Yes	Yes	Yes	No
Replacement String	Yes	Yes	Yes	Yes	No
Replacement Target	Yes	Yes	No	Yes	No

Replacement string.

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)	Display 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.