Solved

Need help in removing special character

  • 16 June 2022
  • 6 replies
  • 154 views
MohammedSohail
Rank

[
{
"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

Rishi
Rank
Userlevel 4
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.

1 Attachment
MohammedSohail
Rank

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  

 

Rishi
Rank
Userlevel 4
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"}}

 

1 Attachment
MohammedSohail
Rank

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

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

 

yes the same

MohammedSohail
Rank

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

Rishi
Rank
Userlevel 4
Badge

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

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

 

Reply


Terms & Conditions