Skip to main content
LEFT_PART

Retrieves the leftmost characters from a text string.

Updated over a month ago

Description

The LEFT_PART() function allows you to extract a specified number of characters from the beginning (left side) of a text string. This is useful for tasks like truncating text or extracting prefixes.

Syntax

LEFT_PART(text, number)

Output

text

Variables

  1. text: The input text string from which you want to extract characters.

  2. number: The number (length) of characters to extract from the left side of the text.

Example

LEFT_PART(`Text`, 5)

ID

Text

LEFT_PART

1

Hello, World!

Hello

2

Example Text

Examp

3

Savant Analytics

Savan

Did this answer your question?