LEFT_SUBSTR

Retrieves the leftmost characters from a text string

Updated over a week ago

Description

The LEFT_SUBSTR() 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_SUBSTR(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_SUBSTR(`Text`,5)

ID

Text

LEFT_SUBSTR

1

Hello, World!

Hello

2

Example Text

Examp

3

Savant Analytics

Savan

Did this answer your question?