LEFT
edit
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 |