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

joemkcarr
8 - Asteroid
 
Tais
5 - Atom

Very useful.

My solution is attached.

lordoforange
7 - Meteor

Here is my solution

gustavosf
5 - Atom

Hi,

 

my solution attached here.

 

I Used a "Text to column" tool to split the text into columns, then select to change the names and the format of Poem_Id.

Then a RegEx tool to delete " from variable poem and another RegEx to replace ' at "Poem_Read_date". Tehn I used DateTime to convert "Poem_Read_date" to date.

jdemeaux
8 - Asteroid

didn't check the solution yet but this one works

DivyaPNair
5 - Atom

Attached My Solution

PeterF
8 - Asteroid
 
Steph_Maddrell
8 - Asteroid

My solution attached

CJacob
5 - Atom

Here's my solution :)

ryantsullivan
6 - Meteoroid

Are we still able to complete old challenges? If so, my solution is attached!