len

Returns the length of a variable.

When the variable is a string, the function returns the number of characters.

When the variable is a list, the function returns the number of values.

Parameters

The function returns the number of characters in a string.

ATL in Script	Result	Notes
`[[len('Hello')]]`	5	There are five characters in the string.
`[[len('Hello, world!')]]`	13	Whitespace characters are counted.

The function returns the number of values in a list.

ATL in Script	Result
`[[myList = makeList(); len(myList)]]`	0
`[[myList = makeList('Linda', 'Kapila', 'Ashwinie'); len(myList)]]`	3

Assume a "Describe Row in Context" project with this data:

Use a variable or ATL function to get a list of values, then use len to count the values.

ATL in Script	Result
`[[RowNames]]`	New York, Boston, Baltimore and Pittsburgh
`[[len(RowNames)]]`	4
`[[rows('New York')]]`	Eric Blair and 1,204,851.24
`[[len(rows('New York'))]]`	2

To count the characters in an individual cell, use the cell and value functions together.

ATL in Script	Result
`[[cell('New York', ManagerColumn)]]`	Eric Blair
`[[len(value(cell('New York', ManagerColumn)))]]`	10