> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# TextJoin

> Use the Sigma TextJoin function to combine multiple text strings into a single string separated by a delimiter.

The **TextJoin** function combines multiple text strings into a single string, inserting a delimiter between each value.

## Syntax

```
TextJoin(delimiter, string_1, string_2, ...)
```

Function arguments:

|                |                                                                  |
| :------------- | :--------------------------------------------------------------- |
| **delimiter**  | (required) String to insert between each of the combined values. |
| **string\_1**  | (required) First string to combine in the sequence.              |
| **string\_2+** | (optional) Additional strings to combine in the sequence.        |

## Notes

* The delimiter is inserted only between values. It isn't added before the first value or after the last value.
* All arguments must be text. To combine a value of another data type with text data, convert the value to text using quotation marks or the **[Text](/docs/text)** function, such as `Text([ID Number])`.
* A `null` value is treated as an empty string. The delimiter is still inserted on both sides of it, which produces consecutive delimiters in the output.
* To combine strings without a delimiter, use the **[Concat](/docs/concat)** function.

## Examples

```
TextJoin("-", "555", "867", "5309")
```

Returns `555-867-5309`.

```
TextJoin(", ", "Lincoln", Null, "Abe")
```

Returns `Lincoln, , Abe`. The `Null` value is treated as an empty string, so the delimiter is still inserted around it.

```
TextJoin(" to ", [Start Station Name], [End Station Name])
```

Returns the start and end station names joined by `to`, such as `South Van Ness at Market to South Van Ness at Market`.

![A table titled TRIP with Start Station Name, End Station Name, and Trip path columns. The Trip path column combines the two station names with the word to between them, so the row with Spear at Folsom and Embarcadero at Bryant returns Spear at Folsom to Embarcadero at Bryant.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/9b8414743e22d67c7a7eb316aa24057fa52e5e8df87c0cc4771b7e29b800af38/assets/docs-images/textjoin-trip-path-example.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260901%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260901T003114Z&X-Amz-Expires=604800&X-Amz-Signature=23bad4ddad72024a4cac2f78f32b8c353defd9155ce84ddb5757132104e5d72c&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

```
TextJoin(" to ", [Start Station Name], [Transfer Station Name], [End Station Name])
```

Returns the three station names joined by `to`. Because the delimiter is specified only once, you can add stops to the sequence without repeating it.

![A table titled TRIP with Start Station Name, Transfer Station Name, End Station Name, and Trip path columns. The Trip path column combines all three station names with the word to between them, so the row with San Jose City Hall, Market at 4th, and San Jose City Hall returns San Jose City Hall to Market at 4th to San Jose City Hall.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/f6aa7f04378b7d02c269d84a6b536383ddd162467f83dba3c0104fba88793ccc/assets/docs-images/textjoin-trip-path-three-column-example.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260901%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260901T003114Z&X-Amz-Expires=604800&X-Amz-Signature=0d8451555315dcc47e629e91d1371e1a56085e09b69831789fdb3c754cc74c6e&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

## Related resources

* [Concat](/docs/concat)
* [SplitPart](/docs/splitpart)