# Wanted to extract /trim

**URL:** <https://community.amazonquick.com/t/wanted-to-extract-trim/45396>\
**Category:** Q&A\
**Tags:** dashboard-embed, developer, quick-sight\
**Created:** [April 24, 2025, 7:21pm UTC](https://community.amazonquick.com/t/wanted-to-extract-trim/45396 "2025-04-24T19:21:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jkethamreddy](https://avatars.discourse-cdn.com/v4/letter/j/9f8e36/32.png) [@jkethamreddy](https://community.amazonquick.com/u/jkethamreddy)\
**Post date:** [April 24, 2025, 7:21pm UTC](https://community.amazonquick.com/t/wanted-to-extract-trim/45396/1 "2025-04-24T19:21:52Z")

</div>

i have field contain below and need to get status and map into another new field then later get count of new field

{“status”:“Passed”,“id”:3633XXX,“exe\_start\_date”:“2023-08-07T13:34:28-05:00”,“exe\_end\_date”:“2023-08-07T13:34:47-05:00”}

---

<div class="post-metadata">

**Author:** ![prantika\_sinha](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/prantika_sinha/32/21878_2.png) [@prantika\_sinha](https://community.amazonquick.com/u/prantika_sinha)\
**Post date:** [April 24, 2025, 7:58pm UTC](https://community.amazonquick.com/t/wanted-to-extract-trim/45396/2 "2025-04-24T19:58:26Z")

</div>

Hi @jkethamreddy ,

Welcome to the Quick Sight Community!!

You can use [Split](https://docs.aws.amazon.com/quicksight/latest/user/split-function.html) to split the text. You can nest one split within another to achieve this.

You can try something like :  
Split(  
Split(  
_text field_,  
_delimiter e.g. “status”: "_ ,  
2),  
_delimiter2 e.g. “,”_ ,  
1)

Thanks,  
Prantika

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [April 26, 2025, 3:46am UTC](https://community.amazonquick.com/t/wanted-to-extract-trim/45396/3 "2025-04-26T03:46:35Z")

</div>

Hi @jkethamreddy - Can you please provide your expected output?

Regards - Sanjeeb

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [May 7, 2025, 9:37pm UTC](https://community.amazonquick.com/t/wanted-to-extract-trim/45396/4 "2025-05-07T21:37:44Z")

</div>

Hi @jkethamreddy,  
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [May 12, 2025, 2:34pm UTC](https://community.amazonquick.com/t/wanted-to-extract-trim/45396/5 "2025-05-12T14:34:32Z")

</div>

Hi @jkethamreddy,  
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you