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 #2: Preparing Delimited Data

chriswilliams41
10 - Fireball
10 - Fireball

I was just messing around with this a little and came up with this solution. 

daltonclouse
5 - Atom
 
CobusVenter
7 - Meteor

Hi.

Here is my solution:

sachin02
8 - Asteroid

My solution:

kexelby
7 - Meteor

My solution to this weeks challenge! 

AmNotARobot
8 - Asteroid

Pleased with my results, although your solution is more concise. Nice to know your solution did not match the byte count for the target output either; nice - as in - I am not alone.

mmccowin
6 - Meteoroid

Just a simple Text to Columns, and a trim function for this one. I had to double check how to get rid of single quotes (" ' ") and double quotes (' " ') in the trim function.

 

 

image.png

sprodger
8 - Asteroid

My Solution:

 

Spoiler
challenge_2_solution_SP.JPG
michael_heitz
8 - Asteroid

Here's my solution! Could probably do it with a tool less if I knew regex better!

NSASPORTES
5 - Atom

Hi,

 

Here's my solution for this exercice :

 

Spoiler
workflow.PNG