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

Preparing Delimited Data

mattreynolds
Comet

Excellent speed challenge!

ZKK
Atom

Tried with Date time tool

mehraamanin
Meteoroid

solution

jerrytran
Meteoroid
Spoiler
PreparingDelimitedData_Workflow.jpgPreparingDelimitedData_Workflow.jpg

Nice feature to be able to select strings using single quotes or double quotes

way2cuul
Meteoroid

Completed

JP_SDAK
Asteroid

I was curious how to do this with least number of tools, so did it3 ways (and left all 3 in my solution).  Looks like formula tool and REGEX replace won.

Huy2508
Atom

My beginner attempt...

clintonang
Meteor

Hi all,

 

Fun challenge. Solution uploaded.

 

Cheers