Wanted to extract /trim

Q&A
,
1

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”}

2

Hi @jkethamreddy ,

Welcome to the Quick Sight Community!!

You can use Split 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

1 Like
3

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

Regards - Sanjeeb

4

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!

5

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