> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: LTRIM

> Remove leading spaces from a string field value while keeping trailing spaces. Use LTRIM to clean the start of imported text in ETL jobs.

## Description

Removes leading spaces from a string field. Trailing spaces are kept.

Only the space character is removed. Leading tabs and line breaks are kept. To remove all leading and trailing whitespace, use [TRIM](https://www.integrate.io/docs/etl/trim.md). To remove only trailing spaces, use [RTRIM](https://www.integrate.io/docs/etl/rtrim.md).

## Syntax

`LTRIM(string_expression)`

## Examples

`LTRIM('  John Smith   ')` returns 'John Smith   '

`UPPER(LTRIM(RTRIM('  ab  ')))` returns 'AB'

## Return value datatype

String

## Impact of null value

If input is null, returns null.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.