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!

Saqueador
Challenge 114.PNG
dkungu
Asteroide

solution

asultanov
Asteroide
Saqueador
Screenshot 2024-02-02 142349.png
Tgigs
Asteroide

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
Quasar

Solved

Bobbyt23
Asteroide

Changed the output and looks good now!

Challenge 114.jpg