Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

radu_gabriel
6 - Meteoroid

My solution

lauramaestuvazquez
7 - Meteor

Here you can find my solution. For learning purposes, I propose three alternatives:

 

  • Using the Python tool
  • Using the RegEx tool
  • Using the Formula tool
TheOC
15 - Aurora
15 - Aurora

A nice challenge

 

Spoiler
TheOC_0-1634301890689.png

 


Bulien
TSteadman30
7 - Meteor

Very enjoyable!

rswathi
6 - Meteoroid

My solution

JMH3
6 - Meteoroid

Nice Challenge

ainderike
8 - Asteroid

My solution is attached. Great first challenge!

ahmedirfanp
7 - Meteor

The first challenge I worked on by Myself. The strip quote function came in handy.

 

ahmedirfanp_0-1634406037606.png

 

winsarg
5 - Atom

😁My solution was a bit different. Instead of using the formula tool I expanded the parameters of the Text to Columns tool to include " and ' as delimiters instead of just the columns. Then I used a date time tool to fix the date formatting, and a select tool to eliminate unnecessary columns and rename the ones I wanted to keep.

Uazir
6 - Meteoroid

Nice example.