We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #114: Think Like a CSE...Remove the extra delimiter from the JSON output

AkimasaKajitani
15 - Aurora

My solution.

Spoiler
AkimasaKajitani_0-1601299686459.png

 

But I want to know how I use the Json file type at the Output data tool.

JP_SDAK
8 - Asteroid

Like others, I found help on Community posts. Thank you Community!

Spoiler
Since the JSON builder was used, writing to file with JSON output type does a double conversion and breaks it.  I changed the output type to CSV, used null delimiter '\0', and changed to Never for Quote Output Fields. This does the trick and gets rid of the extra delimiter ‘\’. 
JP_SDAK_0-1610325451710.png

 

JP_SDAK_2-1610325555925.png

 


 

AndrewS
11 - Bolide

#114

Spoiler
114.PNG

 

mot
11 - Bolide

Solution attached.

rcarog
8 - Asteroid

Solution attached.

mpennington
11 - Bolide

Like many, leveraged the community search to reveal the issue.  Solution attached.

 

Spoiler
\0\0

 

 

apathetichell
16 - Nebula

Interesting...

Sashikumar
8 - Asteroid

My Solution , Changing the Delimiter to \0 in output file.

Spoiler
ch114.PNG
tammybrown_tds
8 - Asteroid

I almost think I could be a CSE!

 

Spoiler
tammybrown_tds_0-1621375749886.png

 

tammybrown_tds_1-1621375765632.png

 

BeginnerMindset
8 - Asteroid

Thanks to help from the community.