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 #16: Parsing Out the New-line Character

numbercruncher
6 - Meteoroid
 
ZenonH
8 - Asteroid

Quick solution, but I learned that while Regex Fields can interpret RegEx, the output field does not work the same way. I needed to use a literal space instead of \s

Spoiler
ZHSOL.png
schenkelpat
7 - Meteor
 
TomProwse
8 - Asteroid
 
Dazzerman
11 - Bolide

Here is my solution :

 

Spoiler
I decided to use the REGEX_Replace function in the Formula Tool to remove the Newline character this time, then use the DateTime Tool to format the Date.

Challenge16.jpg
tony_beck
6 - Meteoroid
Spoiler
clipboard_image_1.png

Little more difficult that the others! 

SueDonim
8 - Asteroid

Nice one for chalking up a quick win (and addition to my challenge tote board)

 

Also nice to see my fear of RegEx going away (I had skipped this one a few weeks ago)

 

Spoiler
Process:
- RegEx replace "\n" with " "
- Date Time tool on dd-Mon.-yy
- Select for cleanup

MySolution.PNG
sgrabish1
8 - Asteroid

Easy to do with guide alongside; thanks for practice

ademinaction
6 - Meteoroid
Spoiler
SPOILER

Here is my solution:

Christoph_Ebersbach
8 - Asteroid

Quick one in my opinion..

 

Thanks for the challenge! Always good to save some time ;). There are some I truly spend more time than the avg. user 🙂