# Is there a way to remove "\[" from the JSON data type column

**URL:** <https://forum.knime.com/t/is-there-a-way-to-remove-from-the-json-data-type-column/46757>\
**Category:** KNIME Analytics Platform\
**Created:** [September 5, 2022, 5:49pm UTC](https://forum.knime.com/t/is-there-a-way-to-remove-from-the-json-data-type-column/46757 "2022-09-05T17:49:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pragadeshgp](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/7ea924/32.png) [@Pragadeshgp](https://forum.knime.com/u/Pragadeshgp)\
**Post date:** [September 5, 2022, 5:49pm UTC](https://forum.knime.com/t/is-there-a-way-to-remove-from-the-json-data-type-column/46757/1 "2022-09-05T17:49:56Z")

</div>

Hi Team,

Is there a way to remove the “[” and “]” from the JSON data type column as shown below?

![image](https://forum-cdn.knime.com/uploads/default/original/3X/9/8/9808437fffb54b09482eb2489a2ded5cf835477d.png)

Thanks & Regards,  
Pragadesh P

---

<div class="post-metadata">

**Author:** ![temesgen-dadi](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/f475e1/32.png) [@temesgen-dadi](https://forum.knime.com/u/temesgen-dadi)\
**Post date:** [September 7, 2022, 7:59am UTC](https://forum.knime.com/t/is-there-a-way-to-remove-from-the-json-data-type-column/46757/2 "2022-09-07T07:59:45Z")

</div>

@Pragadeshgp

First of all, why do you want to remove the brackets? If you do, it won’t be a valid JSON.  
But, you still can use the string replacer node, with the setting shown in the screenshot below, to do what you want. You will be replacing the regex `\[|\]` with empty string.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/d/8/d87efd251caec4075bd3acd485873db78c3cbce9.jpeg)

The column will lose it’s JSON data type and becomes a regular string though.

Best,  
Temesgen

---

<div class="post-metadata">

**Author:** ![Pragadeshgp](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/7ea924/32.png) [@Pragadeshgp](https://forum.knime.com/u/Pragadeshgp)\
**Post date:** [September 7, 2022, 4:53pm UTC](https://forum.knime.com/t/is-there-a-way-to-remove-from-the-json-data-type-column/46757/3 "2022-09-07T16:53:38Z")

</div>

@temesgen-dadi thank you for your explanation.

its helpful.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [December 6, 2022, 4:54pm UTC](https://forum.knime.com/t/is-there-a-way-to-remove-from-the-json-data-type-column/46757/4 "2022-12-06T16:54:15Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.