LEFT - Returning the First Character(s) in a String- FineDataLink Help Document

Last update: May 30, 2025

Overview

Syntax	LEFT(Text, Character count)	Returns the first character or characters in a text string, based on the number of characters you specify.
Parameter 1	Text	Contains the characters to be extracted
Parameter 2	Character count	The specified number of characters to be returned. The character count should be greater than or equal to 0.
Return Value Type	Text

Notes

The function supports two parameters. The first is of the text type. The second is of the numeric type and can be omitted.
If the character count is greater than the length of the text string, the LEFT() function returns all text. If omitted, the default value 1 is used.
If any parameter value is NULL, the result is NULL.

Example

For example, to extract the first seven characters of the Migration_Route field, add a New Calculation Column operator in the Data Transformation node, and input the formula LEFT(Migration_Route,7) as shown in the following figure.

Click Data Preview to view the extracted substring in the new column, as shown in the following figure.

Previous：RIGHT - Returning the Last Character(s) in a String

Next：LEN - Returning String Length

Helpful
Not helpful
Only read

中文（简体）

English

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

Overview

Notes

Example

附件列表