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

Hi Team,

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

image

Thanks & Regards,
Pragadesh P

@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.

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

Best,
Temesgen

1 Like

@temesgen-dadi thank you for your explanation.

its helpful.