﻿---
title: ES|QL RTRIM function
description: 
url: https://www.elastic.co/elastic/docs-builder/docs/2975/reference/query-languages/esql/functions-operators/string-functions/rtrim
products:
  - Elasticsearch
---

# ES|QL RTRIM function
## Syntax

![Embedded](https://www.elastic.co/elastic/docs-builder/docs/2975/reference/query-languages/esql/images/functions/rtrim.svg)


## Parameters

<definitions>
  <definition term="string">
    String expression. If `null`, the function returns `null`.
  </definition>
</definitions>


## Description

Removes trailing whitespaces from a string.

## Supported types


| string  | result  |
|---------|---------|
| keyword | keyword |
| text    | keyword |


## Example

```esql
ROW message = "   some text  ",  color = " red "
| EVAL message = RTRIM(message)
| EVAL color = RTRIM(color)
| EVAL message = CONCAT("'", message, "'")
| EVAL color = CONCAT("'", color, "'")
```


| message:keyword | color:keyword |
|-----------------|---------------|
| '   some text'  | ' red'        |