Solved

Need help in removing special character

  • 16 June 2022
  • 6 replies
  • 73 views

[
{
"domain":"{\n\t\t\"id\": \"7330-2ade99\"\n\t\t\n}"
}
]

 

 

How to remove “\n\t\t”

icon

Best answer by Rishi 16 June 2022, 09:09

View original

6 replies

Userlevel 3
Badge

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" }

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

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

 

yes the same

Userlevel 3
Badge

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  

 

Userlevel 3
Badge

@MohammedSohail , I did export from DataCollector, and hence when you are trying to import in control hub it’s failing. I am attaching the export for SCH. Please try new attached pipeline to import.

Reply