# I want to split a entire column with a delimiter ' ; '

**URL:** <https://community.amazonquick.com/t/i-want-to-split-a-entire-column-with-a-delimiter/8849>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [January 5, 2023, 5:01pm UTC](https://community.amazonquick.com/t/i-want-to-split-a-entire-column-with-a-delimiter/8849 "2023-01-05T17:01:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prashanthkc](https://avatars.discourse-cdn.com/v4/letter/p/ea666f/32.png) [@Prashanthkc](https://community.amazonquick.com/u/Prashanthkc)\
**Post date:** [January 5, 2023, 5:01pm UTC](https://community.amazonquick.com/t/i-want-to-split-a-entire-column-with-a-delimiter/8849/1 "2023-01-05T17:01:47Z")

</div>

I want to split a entire column with a delimiter ’ ; ’

---

<div class="post-metadata">

**Author:** ![todd.hoffman](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/todd.hoffman/32/16346_2.png) [@todd.hoffman](https://community.amazonquick.com/u/todd.hoffman)\
**Post date:** [January 5, 2023, 7:46pm UTC](https://community.amazonquick.com/t/i-want-to-split-a-entire-column-with-a-delimiter/8849/2 "2023-01-05T19:46:45Z")

</div>

Hi @Prashanthkc. You’ll want to create a calculated field using the split function.

Something like: split({field}, ‘;’, 2)

> **[Split - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/split-function.html)**
>
> Use the split function for calculated fields in Amazon QuickSight.

---

<div class="post-metadata">

**Author:** ![Prashanthkc](https://avatars.discourse-cdn.com/v4/letter/p/ea666f/32.png) [@Prashanthkc](https://community.amazonquick.com/u/Prashanthkc)\
**Post date:** [January 6, 2023, 9:59am UTC](https://community.amazonquick.com/t/i-want-to-split-a-entire-column-with-a-delimiter/8849/3 "2023-01-06T09:59:42Z")

</div>

i used the same but its giving error

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/5/5b4c2d10d3ed27ddc037ed13de53ada64ba9f96d.png)

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [January 19, 2023, 9:20pm UTC](https://community.amazonquick.com/t/i-want-to-split-a-entire-column-with-a-delimiter/8849/4 "2023-01-19T21:20:55Z")

</div>

the ‘’ quotes are incorrect. Can you change it to the regular quotes?

Something to note it will only grab the specific index.