HCL Domino - Examples: @Trim - Need a Domino Consultant? Call NotesMail +1 212-599-2048

HCLSoftware Business Partner Domino Consulting Services CRUCIAL Notes Tools +1 212-599-2048	Domino Consulting Services CRUCIAL Notes Tools Domino administration Notes development	Chat now
.

Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

FORMULA LANGUAGE

Examples: @Trim
1. This example returns ROBERT SMITH.

@Trim(@UpperCase("Robert Smith "))

2. This example returns ROBERT SMITH.

@UpperCase(@Trim(" Robert Smith"))

3. This example returns Just a quick reminder, if the original Topic field is "Just a quick reminder."

@Trim(Topic)

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.

@Trim(City:StateOrProvince:Country)

5. This example returns 45 if the content of the field Date is 8/29/89 16:30:45.

@Trim(@Text(@Second(Date)))

6. This input translation formula replaces all tabs and newlines with spaces then trims the field.

@Trim(@ReplaceSubstring(@ThisValue; @Char(9) : @NewLine; " "))

See Also

@Trim

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Feedback on Help or Usability?

Help on Help

All Help Contents