LEN - Returning String Length

对此内容反馈

Last update: May 30, 2025

Overview

Syntax	LEN(Text/Numeric)	Returns the number of characters in a text string.
Parameter	Text/Numeric	The Text/Numeric to be converted If any parameter value is NULL, the result is NULL.
Return Value Type	Numeric

Syntax

LEN(Text/Numeric)

Returns the number of characters in a text string.

Parameter

Text/Numeric

The Text/Numeric to be converted

If any parameter value is NULL, the result is NULL.

Return Value Type

Numeric

Example

For example, to obtain the length of text strings in the Owner_Address field, add a New Calculation Column operator in the Data Transformation node and input the formula LEN(Owner_Address), as shown in the following figure.

Click Data Preview. You can view the number of characters of Owner_Address values in the new Length column, as shown in the following figure.