User Manual

10.03.2024

MANUAL

Formula (Extended): $LEFT Function

## Overview Return the specified number of characters from the beginning of a string. ## Syntax ``` $LEFT(String,[Number of characters]) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |String|Any 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)|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. | ## Usage Example ① Specify the parameter by the screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/4309eb7b116a4f84aec64f4a8e86c369) ### Parameters ![image](https://pleasanter.org/binaries/1a3921e2d9ae4b959c171442e7f71d99) ### Calculation Result ![image](https://pleasanter.org/binaries/73be0b3630874c969b8e06eac5e013b8) ## Usage Example ② Specify the parameter [Number of characters] ### Formula ![image](https://pleasanter.org/binaries/4723ed176fff49dfaa9df3b9c7fc6294) ### Parameters ![image](https://pleasanter.org/binaries/71be8e97ce1c4440bd825783420d3dd6) ### Calculation Result ![image](https://pleasanter.org/binaries/b4e4ae2d52104b1d8ab11b5db3b58b7e)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.