Hi

Could you please help on how to delete string in json. below is the my sample example.

(pdi 7.1 , java 1.7 , MySQL database)

i want to delete second value i.e. comments{1}. could you please tell me some step or procedure to delete in JSON. I verified it google and i got json_replace function but it is not able to delete automatic process.

We need to delete junk data in thousands so please help on this.

[{"comments": [{"id": 1, "comments": "Int", "entityId": 10327, "createdBy": 1162, "updatedBy": 1162, "entityName": "Par", "Type": "Int", "Date": "07-19-2016 07:46:43", "Date": "07-19-2016 07:46:43", "User": "ADMIN", "User": "ADMIN"}, {"id": 2, "comments": "Ext", "entityId": 10327, "createdBy": 1162, "updatedBy": 1162, "entityName": "Par", "Type": "Ext", "Date": "07-19-2016 07:46:43", "Date": "07-19-2016 07:46:43", "User": "ADMIN", "User": "ADMIN"} ]}]

Thank you