Search

Close

Start Free Trial

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.jpg

Just completed this as my first ever weekly challenge! Looking forward to doing more going forwards.

Challenge2_Preparing_Delimited_Data_WJ_21.10.22.PNG

Next :)

Was basic one, little easy to crack

However was a good one to refresh the DateTime tool

421 KB

my solution

Number two down

Here is my solution using the text to column, datetime and select tools.

A great challenge, learnt about the new functions!

Used text to columns to split on comma delimiter and strip quotes function to remove quote marks. Used date-time function to alter the text data to date data type.

Used text to columns to split on comma delimiter and strip quotes function to remove quote marks. Used date-time function to alter the text data to date data type.

My take on this challenge :)

Live Weekly Challenge