User Manual

10.03.2024

MANUAL

Formula (Extended): $RIGHT Function

## Overview Return the specified number of characters from the end of a string. ## Syntax ``` $RIGHT(String,[Number of characters]) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |String|Arbitrary String|Required|| |[Number of characters]|Half-width numerical value. Integer of 0 or more|Optional|Specify the number of characters to be extracted. If omitted, it is assumed that 1 is specified. If 0 is specified, an empty string is returned. | ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |String|Yes|Yes|Yes|Yes|No| |[Number of characters]|Yes|Yes|No|Yes|No| ## Return Value The extracted string. If [Number of characters] is greater than the number of characters in the string, the entire string is returned. ### Return Value Display Content |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. If the return value is a half-width numerical value and 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 ① Specify the parameter by the screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/6a5508ce6cce40a7a853716c7a2c168c) ### Parameters ![image](https://pleasanter.org/binaries/4ebeffa958c444759efd2e84e84a419b) ### Calculation Result ![image](https://pleasanter.org/binaries/4fb240fbcdae45b8bec645714e23a8ed) ## Usage Example ② Specify the parameter [Number of characters] ### Formula ![image](https://pleasanter.org/binaries/1fa886908d0449e79266a72dae9e264f) ### Parameters ![image](https://pleasanter.org/binaries/0983499b9f3f4459a45c6a711ec05b23) ### Calculation Result ![image](https://pleasanter.org/binaries/9d74007532cf4e00ba171f2b611a9558)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.