community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #2: Preparing Delimited Data

Atom

clipboard_image_0.png

Highlighted
Meteor

Done! 

Meteor
Spoiler
I started by removing all punctuation save for the hyphens in the dates, then converting the date format and then using a select tool to clean-up and rename the data challenge_2_solution_BL.png
Spoiler
 
Moderator
Moderator

Regex!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Customer Support Engineer
Alteryx, Inc.
Meteor
Spoiler
Challenge2_Preparing Delimited Data.jpg
Meteor
 
Alteryx
Alteryx

My Solution

Spoiler
Weekly Challenge_2_AJM.png

Just joined the community and solved my first weekly challenge

Meteor

 

Spoiler
clipboard_image_0.png

 

 

 

This is my solution using Reg Ex (this is the first time i use reg ex tool)

Meteor

My Solution: