trim

To remove preceding and following spaces

Especially when copying & pasting 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 settings 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 updated