## Overview Convert a specific string in the target string to a specified string. ## Syntax ``` $SUBSTITUTE(Target String,Search String,Replacement String,[Replacement Target]) ``` ## Parameters |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. | ### Column Usable as Parameters |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| ## Return Value Replacement string. ### Return Value for Target Column |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. | ## Usage Example 1 Specify the parameter by the screen column name (name displayed) ### Formula  ### Parameters  ### Calculation Result  ## Usage Example 2 Specify the parameter as [Replacement Target] ### Formula  ### Parameters  ### Calculation Result