![]() |
Next Page |
| Contents > Functions reference (alphabetical list) > Text functions > Length function |
|
|
| Length function |
| Format |
Length(field) |
| Parameter |
| field - any text, number, date, time, timestamp, or container field, or any text expression or numeric expression |
| Data type returned |
| number |
| Description |
| Returns the number of characters in field, including all spaces, numbers, and special characters. For a container field, Length returns the total stored size of objects in bytes. |
| Examples |
| Length("John") returns 4. |
| Length(Description) returns 12 when the value in Description is Modem for PC. |
| Length("M1" & Left(Product;5)) returns 7, when the Product field contains Canvas Backpack. |
| Related topics |
| Functions reference (category list) |
| Functions reference (alphabetical list) |
| About formulas |
| About functions |
| Defining calculation fields |
| Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > Length function | Next Page |