Need help in removing special character

Hii @MohammedSohail , How does the output record should look like ? is it as below or something else ?

domain : { "id": "7330-2ade99" }

@Rishi you are correct I need same :   domain : { "id": "7330-2ade99" }

domain : { "id": "7330-2ade99" }

yes the same

Hello @MohammedSohail , Can you try as below , Please find attached pipeline json for your reference.

Input Flile

❯ cat /tmp/test.json                                                                                                                                             
   1   │ [
   2   │ {
   3   │ "domain":"{\n\t\t\"id\": \"7330-2ade99\"\n\t\t\n}"
   4   │ }
   5   │ ]

Output file

 $cat sdc-32eca88c-c316-11ec-a3e9-d3b91a74f13a_c52862ca-c016-483f-b380-9077c3019fdb    

   1   │ {"domain":{"id":"7330-2ade99"}}

Hello @MohammedSohail , Can you try as below , Please find attached pipeline json for your reference.

 

Input Flile

❯ cat /tmp/test.json                                                                                                                                             
   1   │ [
   2   │ {
   3   │ "domain":"{\n\t\t\"id\": \"7330-2ade99\"\n\t\t\n}"
   4   │ }
   5   │ ]

 

Output file

 $cat sdc-32eca88c-c316-11ec-a3e9-d3b91a74f13a_c52862ca-c016-483f-b380-9077c3019fdb    

   1   │ {"domain":{"id":"7330-2ade99"}}

 

Sorry If i am doing wrong , as I am new to streamset