Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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.