Free Trial

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 #11: Identify Logical Groups

meeravijayan2011
8 - Asteroid
Spoiler
11.png
AryCardoso
8 - Asteroid
 
jchua3
7 - Meteor

solved by splitting up the find replace table and joining back again

LindaLo
8 - Asteroid

quite like this challenge!

 

Simonvm9114
8 - Asteroid

Fun and rather simple challange.

Spoiler
I forgot about the cleaning of the numbers though. Good point. I used the contains function to find the search in the complained, think that worked a bit easier than splitting every word.
sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1581108895055.png
Blake
12 - Quasar
Spoiler
Blake_0-1581448256276.png
mikeprice17
8 - Asteroid

I think the directions were a little confusing. I was originally looking for the counts of those in each of the records, not just flagging if the record had the word. But figured it out. 

WegmanJordy
7 - Meteor

Hereby the solution

dark_a
7 - Meteor

Basically it is possible to do it using Find Replace tool, bet for some reason this tool is doing search in first 250 characters. I don't know why. So there is workaround.