# Trim

Values sometimes have spaces at the start or end because of mistakes in data entry or the use of a split operation to break apart a CSV (comma separated list). These aren't always easily visible but can cause problems if you're trying to do exact matches for a [Lookup/Join](https://github.com/concentra-analytics/working-with-data/tree/51c414aad5b91e0da2741a07a436476e362ed6ce/strings/General/Join.md). Trim allows you to strip out trailing or leading characters (usually white space by default) to clean up your text field.

## Excel

\=\~TRIM!\~(‹string›)

```
=TRIM(A1) // " Recruiter " -> "Recruiter"
```

## Tableau

Tableau supports three `TRIM()` operations:

* \~TRIM!\~(‹string›) removes leading and trailing spaces 
* \~LTRIM!\~(‹string›) removes leading spaces only
* \~RTRIM!\~(‹string›) removes trailing spaces only

```
TRIM([Job Role]) // " Recruiter " -> "Recruiter"
```

```
LTRIM([Job Role]) // " Recruiter " -> "Recruiter "
```

```
RTRIM([Job Role]) // " Recruiter " -> " Recruiter"
```

## Alteryx

Alteryx supports three `TRIM()` operations:

* \~TRIM!\~(‹within\_string›«, target\_string») removes leading and trailing characters
* \~TRIMLEFT!\~(‹within\_string›«, target\_string») removes leading characters only
* \~TRIMRIGHT!\~(‹within\_string›«, target\_string») removes trailing characters only

```
TRIM([Job Role]) // " Recruiter " -> "Recruiter"
```

```
TRIMLEFT([Job Role]) // " Recruiter " -> "Recruiter "
```

```
TRIMRIGHT([Job Role]) // " Recruiter " -> " Recruiter"
```

NB. If «target\_string» is excluded, the default behaviour is to trim whitespace. If it is included, you can specify what character to trim:

```
TRIM([Job Coded], "*") // "**HR014**" -> "HR014"
```

## OrgVue

Gizmo does not support `Trim` operations, although OrgVue workspace will usually trim strings by default.

## tSQL

* \~LTRIM!\~(‹string›) removes leading spaces only
* \~RTRIM!\~(‹string›) removes trailing spaces only
* To remove leading *and* trailing spaces, use \~RTRIM!\~(\~LTRIM!\~(‹string›))

```
SELECT LTRIM(JobRole) AS JobRole
FROM EmployeesData
-- " Recruiter " -> "Recruiter "
```

```
SELECT RTRIM(JobRole) AS JobRole
FROM EmployeesData
-- " Recruiter " -> " Recruiter"
```

```
SELECT RTRIM(LTRIM(JobRole)) AS JobRole
FROM EmployeesData
-- " Recruiter " -> "Recruiter"
```

## Python

‹string›.\~strip(«target\_string»)!\~

```
jobRole.strip() # " Recruiter " -> "Recruiter"
# OR
jobCode.strip('*') # " HR014**" -> " HR014"
```

NB.

* If «target\_string» is excluded, the default behaviour is to trim whitespace. 
* If «target\_string» is included, you can specify what character to trim. 
* The above examples assume variables have been declared for `jobRole` and `jobCode`. For more information, go to [General > Variables](https://orgvue.gitbooks.io/formula-translator/content/general/variables.html).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://concentra-analytics.gitbook.io/working-with-data/strings/trim.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.