LEN - Returning String Length- FineDataLink Help Document

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.

Previous：LEFT - Returning the First Character(s) in a String

Next：Logic Function Overview

Helpful
Not helpful
Only read

中文（简体）

English

LEN - Returning String Length

Overview

Example

附件列表