ES|QL LEFT function
string- The string from which to return a substring.
length-
The number of characters to return.
Returns the substring that extracts length chars from string starting from the left.
| string | length | result |
|---|---|---|
| keyword | integer | keyword |
| text | integer | keyword |
FROM employees
| KEEP last_name
| EVAL left = LEFT(last_name, 3)
| last_name:keyword | left:keyword |
|---|---|
| Awdeh | Awd |
| Azuma | Azu |
| Baek | Bae |
| Bamford | Bam |
| Bernatsky | Ber |