Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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