We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #227: /*comments*/

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1678979671590.png

 

dougbaron
8 - Asteroid

very frustrating, but I made it work.

Spoiler
I could not find any other way to filter out id's 557522, 558060, 573692, 561823, 557527, or 556843 other than directly filtering. Other options led to inadvertently filtering out other records. They all have a valid subject line and other fields. The body text contents are all within Spoiler tags with nothing outside the tag which other valid records have as well.  I had to join actual output with expected output by record position to narrow down the record rows to find these id's.

dougbaron_0-1679016864059.png

 

RobertOdera
13 - Pulsar

here is my solution - cheers!

Spoiler
RobertOdera_0-1679242583574.png

 

gaoa
11 - Bolide
Trim(Regex_Replace([body],"<.*?>",''))

Note: different number of records in the output: 

Spoiler
gaoa_0-1679407044578.png
CanalB
8 - Asteroid

my solution

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_227_KU.png
Shifty
12 - Quasar

Nice. 😜

 

Spoiler
Shifty_0-1681208591562.png

 

Carolyn
8 - Asteroid

Solution attached. I had a few more rows than the official solution but I'm calling it close enough :)

leonhekkert
8 - Asteroid

My solution:

 

Spoiler
Challenge_227.png
Shahbaz_analyst
8 - Asteroid
Spoiler
Shahbaz_analyst_0-1686146237595.png