Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 🙂