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

knl538
6 - Meteoroid

Here's my solution to the challenge.

mhou
8 - Asteroid

🙂

Savage
5 - Atom
Spoiler
Spoiler

First challenge completed 🙂

ChriswcNg
5 - Atom

Challenge 2 done. 

EdE
7 - Meteor

My solutions are attached.  I liked the simplicity of the solution provided by the author of the challenge.  

chrisBarbati
6 - Meteoroid

My solution is different from the one posted with the challenge, but the results are the same. 

philliams10
6 - Meteoroid

My solution.

Guillaume_G
8 - Asteroid

Here you go !!

Tylercram
6 - Meteoroid

Processes applied after inputting the starting data

Spoiler
1. Used Text to Columns tool to parse the data into columns based on comma
2. Added a select tool to rename the new columns and exclude the original field from the workflow.
3. Used a RegEx tool to remove double quotes
4. Used a RegEx tool to remove apostrophes
5. Used a Formula tool and conditional statement to convert the Poem_Read_Date to the requested format.

 

 

Nicholas_Norton
8 - Asteroid

I utilized the formula tool more for this workflow!