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

dicksonjoseph15
5 - Atom

Solution

katherinegrubbs
6 - Meteoroid

KG Challenge 2 Solution 5.30.2024

Roshan321
5 - Atom

i completed the challenge 2.

Arran
8 - Asteroid

Awesome

n8fortner
6 - Meteoroid

solution attached

Pravallika2003
7 - Meteor

Preparing Delimited Data

Pavandeep
5 - Atom

Done

erickyaparevalo
7 - Meteor

Hello,

 

here is the second challenge made. This is simpler, but it doesn't mean that you can't learn something. In this case I used RegEx to get all three elements. But the most interesting is that one of the date. I've used the DateTimeParse formula to recognize the date of a date in String. In that case, the specifier "%d-%b-%y" works perfectly. Where %y stand for the last 2 digit of a year and %Y (in caps), in case they year is expressed in 4 digits. But in this case, it works either. The same for %b which stands for the abbreviated month name ("Jun"), it works even it's represented all in caps. Other way, you may need to transform it into Title (using "TitleCase" formula) firstly before try to match.

 

Even with a tiny challenge you can learn something new!

PriAg24
5 - Atom

Answer

chirimoyayachay
8 - Asteroid

Here you go