FORMULA LANGUAGE


Examples: @Trim
1. This example returns ROBERT SMITH.
2. This example returns ROBERT SMITH.
3. This example returns Just a quick reminder, if the original Topic field is "Just a quick reminder."
4. This example returns Seattle;Toronto;Santiago;USA;Canada;Chile if the list of values contained in the City field consists of Seattle, Toronto, Santiago; the StateOrProvince field contains no values; and the Country field contains the list of values USA, Canada, Chile.
5. This example returns 45 if the content of the field Date is 8/29/89 16:30:45.
6. This input translation formula replaces all tabs and newlines with spaces then trims the field.

See Also