Search…
Resources
Related Links
trim
To remove preceding and following spaces
Especially when copy & paste text from another source, it can happen, that you also “import” spaces that are unwanted. These spaces before or after a text will be removed with this function.
But you can also apply prophylactically to values where it’s important that they don’t contain these superfluous spaces.
The function does not affect spaces within the text.
Tipp: Used in Trigger after Update will return a flawless entry.

Syntax

trim(string)

Return

string

Examples

'Last name' := trim('Last name')
Result: Any spaces for or after field contents of the “Last name” field will be removed. Add this function to the field Trigger after Update in the field editor of “Last name” or in an extra button.

See also

​text, which converts a value to a string and possibly reflects the format options.
Last modified 2mo ago
Export as PDF
Copy link