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

OllieClarke
15 - Aurora
15 - Aurora

My solution

Spoiler
Challenge 114.PNG
T_Willins
14 - Magnetar
14 - Magnetar

I came to the same solution, but that seemed too easy.  Finally looked that was the same solution as others.  

Spoiler
Workflow 114.JPG

 

mbogusz
9 - Comet

Even the sanctified solution(s) outputs have a "|" character instead of a space after DRAMA, etc.

 

2019-10-03 22_55_10-Greenshot.png

 

KMiller
8 - Asteroid

Solution attached.

Spoiler
25-10-2019 17-16-34.png
Inactive User
Not applicable
 
dsmdavid
11 - Bolide

Can finally attach files, although cannot edit my previous reply

SueDonim
8 - Asteroid

Thanks to search on Community, found this is a simple fix

 

Spoiler
Process:
- Change output format to .csv
  -- Null (\0) delimiter
  -- Untick First Row Contains Field name

MySolution.PNG
nivi_s
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1577569184519.png
rmassambane
10 - Fireball
 
JamesCameron
8 - Asteroid

My Effort

 

Spoiler
Used a flat file - looking at other solutions, the non-delimited CSV file feels like a more flexible option, as my solution fixes this problem, but not for large amounts of data.
JamesCameron_0-1579192270587.png