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 #279: How many Olympic Games per Continent?

Allan_F
7 - Meteor

Completed with Find/Replace - had to look at solution for the better way lol

surajmthomas
8 - Asteroid

surajmthomas_0-1628658496301.png

 

Freddy123
7 - Meteor
Spoiler
FrederikF_0-1628750094558.png

 

AJ_23
7 - Meteor

My Solution

Uploaded my approach for challenge #279

Ashuu11
7 - Meteor

My solution for Challenge #279.

Hi Team,

 

I have uploaded my solution.

 

Thank You,

Praveen

joshbennett
11 - Bolide
11 - Bolide

Here is my solution!

 

 

jpl5253
7 - Meteor

Submitted late but I promise I didn't look at the solution!! 

kelly_gilbert
13 - Pulsar

Fun! 

 

Workflow:

Spoiler
kelly_gilbert_0-1628789033282.png

Methods:

Spoiler
Method 1: regex
regex_replace([Continent], '\W*([\w\s]+).*', '$1')

Method 2: string functions
trim(
  replace(
    left([Continent], findstring([Continent], '[')),
    '*', '')
)