---
title: "SPLIT"
url: "https://help.formsfly.com/en/article/split"
language: "en"
last_updated: "2024-10-29T10:37:42.582Z"
---

# SPLIT

Splits text input into a List of values based on the specified delimiter character.

### Syntax

SPLIT(input, delimiter, optionalIndex)

### Examples

```plaintext
SPLIT({{nfcField}}, ',', 2) returns the 3rd element in the comma seperated list
SPLIT('AAA|BBB|CCC', '|', 0) is AAA
SPLIT('AAA,BBB,CCC', ',') is a list with AAA, BBB and CCC as it's elements
MAX(SPLIT('1-2-5-4-3', '-')) is 5
SPLIT('AAA,BBB,CCC', ',' , 99) is BLANK as there is not 100 elements in the input list
```

### Notes

The resulting List can be used within aggregate functions such as [SUM()](https://help.formsfly.com/en/article/sum) or [COUNT()](https://help.formsfly.com/en/article/count).  
If optional zero-based index is specified, then returns the single value at the given index or BLANK if the index is not within the list.