Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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