Trim Function
Trim (text as String) as String
Category: | Text |
Description: | Removes all spaces from a text string except for single spaces between words |
Supported Context: | FormulaField And BusinessRules |
Parameters: | |
text as String | Represents a text string or reference to a field that returns a value of type text |
Returned value as String | Returns a text string value equal to the text specified in the "text" parameter with all spaces removed except for single spaces between words |
Example #1 |
Create a formula on a description field that will remove spaces from the start and end of a text string. For example, "this is a test " will return "this is a test". Trim($Description) |
Tips |
|
Related Functions |