# How to use split function with space as the delimiter

**URL:** <https://community.amazonquick.com/t/how-to-use-split-function-with-space-as-the-delimiter/11633>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [March 30, 2023, 1:15am UTC](https://community.amazonquick.com/t/how-to-use-split-function-with-space-as-the-delimiter/11633 "2023-03-30T01:15:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![leiyang](https://avatars.discourse-cdn.com/v4/letter/l/db5fbb/32.png) [@leiyang](https://community.amazonquick.com/u/leiyang)\
**Post date:** [March 30, 2023, 1:15am UTC](https://community.amazonquick.com/t/how-to-use-split-function-with-space-as-the-delimiter/11633/1 "2023-03-30T01:15:57Z")

</div>

I am trying to group my Products using the first portion of the ProductName. I added a calculated field and used the split() function as:

split({ProductName}, ’ ', 1)

but it keeps returning error.

---

<div class="post-metadata">

**Author:** ![drpeter](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/drpeter/32/2772_2.png) [@drpeter](https://community.amazonquick.com/u/drpeter)\
**Post date:** [March 30, 2023, 3:50am UTC](https://community.amazonquick.com/t/how-to-use-split-function-with-space-as-the-delimiter/11633/2 "2023-03-30T03:50:58Z")

</div>

Special character error on the split delimiter, please use single quotes or double quotes; seems the opening quote looks like an apostrophe:

Syntax (Detailed Function Documentation - [click here](https://docs.aws.amazon.com/quicksight/latest/user/split-function.html))  
split(expression, delimiter , position)

Incorrect  
({ProductName}, ’ ', 1)

Correct  
({ProductName}, ’ ', 1)  
or  
({ProductName}, " ", 1)  
 ![Use Single or Double Quotes](https://d1wl4jav5dp96l.cloudfront.net/original/2X/a/a21e5b7904ee2a93431681c37b30ab9d751bd938.png)

 ![Quick Sight Screenshot](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/292427e50428dd120fa39ba4ef824f6cd13667d8.png)