LEFTedit

LEFT(string,length)

Return the substring that extracts length chars from the string starting from the left.

FROM employees
| KEEP last_name
| EVAL left = LEFT(last_name, 3)
| SORT last_name ASC
| LIMIT 5
last_name:keyword left:keyword

Awdeh

Awd

Azuma

Azu

Baek

Bae

Bamford

Bam

Bernatsky

Ber

Supported types:

string length result

keyword

integer

keyword