User Manual

10.03.2024

MANUAL

Formula (Extended): $TRIM Function

## Overview Remove unnecessary spaces before and after a string. Spaces within the string are not removed. ## Syntax ``` $TRIM(string) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |String|Arbitrary String|Required|| ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |String|Yes|Yes|Yes|Yes|No| ## Return Value A string with spaces before and after the string removed. ### Return Value for Target Column |Target|Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. In the case of a drop-down list with values, the options that match the return value are displayed. | |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 in date format. | |Description (including content)|Display return value. | |Check (including lock)|Do not display. | ## Usage Example 1 Specify parameters by screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/d4de8a9c6dcf49d78fc61c293b18be0b) ### Parameters ![image](https://pleasanter.org/binaries/e2c190b2c3dd4218b4543792241b9ac3) ### Calculation Result ![image](https://pleasanter.org/binaries/6a4d9461504947a29e3e29cd4ba76e53)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.