We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #2: Preparing Delimited Data

chriswilliams41
8 - Asteroid

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