Returns the length of a string of text.
Description
If you specify a single string as the argument, the return value is the length as a number. If you specify a single-column table that contains strings, the return value is a single-column table that contains the length of each string. If you have a multi-column table, you can shape it into a single-column table, as working with tables describes.
If you specify an empty string, Len returns 0.
Syntax
Len( String )
- String - Required. The string to measure.
Len( SingleColumnTable )
- SingleColumnTable - Required. A single-column table of strings to measure.
Examples
Single string
For the examples in this section, the data source is a text-input control that's named Author and that contains the string "E. E. Cummings".
| Formula | Description | Result |
| Len( Author.Text ) | Measures the length of the string in the Author control. | 14 |
| Len( "" ) | Measures the length of an empty string. | 0 |
Single-column table
For the first example in this section, the data source is named People and contains this data:
| Formula | Description | Result |
| Len( ShowColumns( People, "Address" ) ) | In the Address column of the People table:
|  |
| Len( [ "Hello", "to the", "World", "" ] ) | In the Value column of the inline table:
|  |