Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

alexnajm
17 - Castor
17 - Castor

Thank goodness for the Community!

Spoiler
Challenge 114.PNG
dkungu
8 - Asteroid

solution

asultanov
8 - Asteroid
Spoiler
Screenshot 2024-02-02 142349.png
Tgigs
8 - Asteroid

My solution attached.

 

What I actually end up doing is change the output type to .csv but keep the .json file extension and change settings to /0 delimiter which means no delimiter, file does not contain headers in first row, and never quote output fields, so this basically just writes our JSON text string into a text file with a .json file extension. When you read the data in as a JSON type with the input tool there are no issues with reading the data in which means that it works.

 

Spoiler.PNG

DanielG
12 - Quasar

Solved

Bobbyt23
8 - Asteroid

Changed the output and looks good now!

Challenge 114.jpg