Challenge #227: /*comments*/

[Ed2000]

スポイラ

[dougbaron]

very frustrating, but I made it work.

スポイラ

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.

[RobertOdera]

here is my solution - cheers!

スポイラ

[gaoa]

Trim(Regex_Replace([body],"<.*?>",''))

Note: different number of records in the output: 

スポイラ

[CanalB]

my solution

[kristiadiuisan]

スポイラ

[Shifty]

Nice. 😜

スポイラ

[Carolyn]

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

[leonhekkert]

My solution:

スポイラ

[Shahbaz_analyst]

スポイラ