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

TejaswiVuyyuru
7 - Meteor

Preparing Delimited Data

mattreynolds
9 - Comet

Excellent speed challenge!

ZKK
5 - Atom

Tried with Date time tool

mehraamanin
6 - Meteoroid

solution

jerrytran
6 - Meteoroid
Spoiler
PreparingDelimitedData_Workflow.jpgPreparingDelimitedData_Workflow.jpg
Tony_Castillo
9 - Comet

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

way2cuul
6 - Meteoroid

Completed

JP_SDAK
8 - 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
5 - Atom

My beginner attempt...

clintonang
7 - Meteor

Hi all,

 

Fun challenge. Solution uploaded.

 

Cheers