# Remove bracket and u from json data in ansi le

**URL:** <https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578>\
**Category:** Ansible Project\
**Created:** [January 25, 2023, 7:39am UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578 "2023-01-25T07:39:04Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abhiroxxx](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Abhiroxxx](https://forum.ansible.com/u/Abhiroxxx)\
**Post date:** [January 25, 2023, 7:39am UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/1 "2023-01-25T07:39:04Z")

</div>

Hello All,

I want remove bracket and u from json data in ansible. I am trying to retrieve data from json.  
I executed this code in playbook

- debug:  
msg: “{{ item }}”  
loop: “{{ raidurl1 | json\_query(‘json.Members[_].[_]’) }}”

I am getting output like

(item=[[u’ /refish/v1/Systems/1’]])

But i want output like  
(item= /redfish/v1/Systems/1 )

How can i remove bracket and u from item. Do i need to change anything in to debug loop? Please help

Thanks and regards,  
Abhi

---

<div class="post-metadata">

**Author:** ![Walter\_Rowe](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/walter_rowe/32/4506_2.png) [@Walter\_Rowe](https://forum.ansible.com/u/Walter_Rowe)\
**Post date:** [January 25, 2023, 1:52pm UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/2 "2023-01-25T13:52:11Z")

</div>

Try piping thru “from\_json | to\_json” or just “to\_json” filter. One of those worked for me. Cannot remember which one.

Walter

---

<div class="post-metadata">

**Author:** ![Abhiroxxx](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Abhiroxxx](https://forum.ansible.com/u/Abhiroxxx)\
**Post date:** [January 25, 2023, 4:44pm UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/3 "2023-01-25T16:44:36Z")

</div>

I tried earlier but no luck… Any other suggestions?

---

<div class="post-metadata">

**Author:** ![dnmvisser](https://avatars.discourse-cdn.com/v4/letter/d/8e8cbc/32.png) [@dnmvisser](https://forum.ansible.com/u/dnmvisser)\
**Post date:** [January 25, 2023, 6:45pm UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/4 "2023-01-25T18:45:45Z")

</div>

The bracket and the u are not just some stray characters, which you seem to think.  
Your data is structured like a nested list, and that is what is being displayed.  
Adjust the json\_query to remove the nested structure.

Also you didn’t post your raidurl1 data so it’s mostly guessing…

---

<div class="post-metadata">

**Author:** ![Abhiroxxx](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Abhiroxxx](https://forum.ansible.com/u/Abhiroxxx)\
**Post date:** [January 27, 2023, 7:04am UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/5 "2023-01-27T07:04:21Z")

</div>

Hi dick,

Please check raidurl1 output attached. Please advice…

Regards,  
Abhijit

> **(attachments)**
>
> ![IMG_20230127_123227.jpg](https://us1.discourse-cdn.com/ansible/original/2X/7/750ae619b7615f1b6aba4f2a8bffa47df35fbaf2.jpeg)

---

<div class="post-metadata">

**Author:** ![Walter\_Rowe](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/walter_rowe/32/4506_2.png) [@Walter\_Rowe](https://forum.ansible.com/u/Walter_Rowe)\
**Post date:** [January 27, 2023, 1:06pm UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/6 "2023-01-27T13:06:50Z")

</div>

raidurl1[‘json’].Members should get you Members JSON list.

raidurl1 | json\_query(‘json.Members[\*].@odata.od’)

OR

raidurl1.json.Members | json\_query(‘[\*].@odata.od’)

Walter

---

<div class="post-metadata">

**Author:** ![Walter\_Rowe](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/walter_rowe/32/4506_2.png) [@Walter\_Rowe](https://forum.ansible.com/u/Walter_Rowe)\
**Post date:** [January 27, 2023, 1:09pm UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/7 "2023-01-27T13:09:11Z")

</div>

[https://docs.ansible.com/ansible/5/collections/community/general/docsite/filter\_guide\_selecting\_json\_data.html](https://docs.ansible.com/ansible/5/collections/community/general/docsite/filter_guide_selecting_json_data.html)

Walter

---

<div class="post-metadata">

**Author:** ![Walter\_Rowe](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/walter_rowe/32/4506_2.png) [@Walter\_Rowe](https://forum.ansible.com/u/Walter_Rowe)\
**Post date:** [January 27, 2023, 1:28pm UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/8 "2023-01-27T13:28:15Z")

</div>

This is the latest documentation.

[https://docs.ansible.com/ansible/latest/collections/community/general/json\_query\_filter.html](https://docs.ansible.com/ansible/latest/collections/community/general/json_query_filter.html)

Walter

---

<div class="post-metadata">

**Author:** ![Abhiroxxx](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Abhiroxxx](https://forum.ansible.com/u/Abhiroxxx)\
**Post date:** [January 28, 2023, 7:17am UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/9 "2023-01-28T07:17:38Z")

</div>

I tried this things as well but getting error… attached screenshot

Regards,  
Abhi

> **(attachments)**
>
> ![IMG_20230128_124419.jpg](https://us1.discourse-cdn.com/ansible/original/2X/3/3770ebe875702a01927075abfa393b5800f0900e.jpeg)

---

<div class="post-metadata">

**Author:** ![Walter\_Rowe](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/walter_rowe/32/4506_2.png) [@Walter\_Rowe](https://forum.ansible.com/u/Walter_Rowe)\
**Post date:** [January 30, 2023, 12:29pm UTC](https://forum.ansible.com/t/remove-bracket-and-u-from-json-data-in-ansi-le/37578/10 "2023-01-30T12:29:07Z")

</div>

I sense it doesn’t like the @ sign as part of an identifier.

Walter