@Length (Formula Language)

Returns the number of characters in a text string.

Syntax

@Length( string ) or

@Length( stringlist )

Parameters

string

Text. A single string with the length you want to find.

stringList

Text list. A list of strings.

Return value

length

  • If the parameter is a text string, @Length returns the number of characters in the specified string, including spaces and punctuation.
  • If the argument is a text list, @Length searches the list of strings and returns the number of characters in each string as a number list.

Examples

  1. This example returns 45.
    @Length("The boy crossed the wide, but gentle, stream.")
  2. This example returns the number list 0:5:3, which displays as 0;5;3 if the multi-value separator for the field is a semicolon.
    @Length("": "abcde": "xyz" )
  3. This example returns the number list 16:10:22 if the contents of the fields From, Topic, and Date are "Stephen Brewster", "News Flash", and @Now (where the current date is 04/01/2001 16:45:10 PM), respectively. The number list displays as 16,10,22 if the multi-value separator for the field is a comma.
    @Length(From: Topic: @Text(Date))