String manipulation

LENGTH – Calculate the number of characters in a field

42 views June 1, 2018 admin 0

Overview

This Custom Field returns the number of characters in the given field.

Syntax

LENGTH(FIELDSTR(FieldName))

FIELDSTR
FieldName The name of the field to return the character length of.

Example

LENGTH(FIELDSTR(Manufacturer))

Manufacturer

LENGTH(FIELDSTR(Manufacturer))

Ford Motor Company 18

Note in the example above that spaces are included.

See also

LEFTSTR

RIGHTSTR

Was this helpful?